Sep 15, 2023 7:54 AM
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.
Sep 21, 2023 12:59 PM - edited Sep 21, 2023 12:59 PM
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))
Sep 21, 2023 1:01 PM
Thanks for sharing this, @nickfromfargo 🙌 — Jaycee
Sep 19, 2023 11:53 AM
Hey, @--Frank-- 👋 Did you make any progress?
If not, I have a few questions to help our community better understand the issue.
Questions:
properties.amount
and what data type is the result of time_between
?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?Best,
Jaycee