Hi @EVersloot ,

This is your branching logic:

And this is what each action after the branch looks like (there is only one.) This is really very simple. We need to know when the year ends.

The property is used for this calculated property:

Also, I want to stress that these formulas are going to caclulate based upon the total elapsed time between the Midnight on the close date and Midnight on New Year's Day in miliseconds. The result should be substantially the same, but there does appear to be some rounding error in the HubSpot Calculated Properties. I am actually finding that the most accurate calculation is achieved by calculating this year's revenue in two steps:

Step 1:

Step 2

There appears to be just too much rounding error trying to use a number bigger than 314,500,000 on the first pass.

Also, be careful about your 366 days. That number is only relevant for deals closed between March 1, 2023 and February 29, 2024. After March 1, 2024 we are back to a 365 day year.

When I take a $12,000 amount, and May 22 close date (223 days left in the year), I get the following:

Which is admittedly off from a spreadsheet calculation by $3.48, or about 0.04%, but it seems like an acceptable margin of error.

- Trevor

If my post solves your problem, please accept it as a solution.