Participante

## Custom Equation: Amount / Time Between

Hi,

Part of our business is selling services. I'd like to create a new Deal Property that gets its value from a calculation.

In two deal properties we set 'Start Date' and 'End Date'. This allows for a quick (and correct) return for 'Project Duration'.

Now I want to use the output of 'Project Duration'  and the deal 'Amount' to calculate the value of a new Deal Property --> Monthly Contract Value.

In my simple attempt, I created this calculation, Amount divided by Project Duration (see below). However, it returns the number Zero.

Tried to multiply the outcome by Milliseconds per Day, but still no luck.

Is this possible at all? Also playing with other functions, I seem to get a lot of errors when trying to save the function.

• ([properties.amount] / time_between([properties.estimated_project_start_date], [properties.estimated_project_end_date__duration_]))
3 Respostas 3
Participante

## Custom Equation: Amount / Time Between

TLDR;The main issue seems to stem from the original equation. I think you are using the duration property in your equation as a time between factor... instead of the end date.

Not totally sure on how I'd do it for a Monthly breakdown, but.

You can do a Revenue per Day calucation all in one calculated property if you cofigure it as below swapping out your appropriate properties. Be sure the Output type is set to Number and formatted to Currency

([properties.amount] / (time_between([properties.estimated_project_start_date], [properties.estimated_project_end_date]) / 86400000))

## Custom Equation: Amount / Time Between

Thanks for sharing this, @nickfromfargo 🙌 — Jaycee

### Jaycee Lewis

Developer Community Manager

Community | HubSpot

## Custom Equation: Amount / Time Between

Hey, @--Frank-- 👋 Did you make any progress?

If not, I have a few questions to help our community better understand the issue.

Questions:

• What data type is `properties.amount` and what data type is the result of `time_between`?
• If `time_between` returns a value in days, are you expecting `Monthly Contract Value` to represent the average amount for each day of the project or for each month?
• Can you share the errors you receive when trying to save the function, please?

Best,

Jaycee

### Jaycee Lewis

Developer Community Manager

Community | HubSpot