HubSpot Ideas

jdtingay

Day of the Year counter

We have a need to calculate the projected sales for a company based on the current value of orders divided by a number that is the current day of the year.

 

For example:

 

Year Projection = (2025 Sales / ((Day Count / 365) * 2024 Sales))

 

I've created a property that resets on the 1st January and then increments through the year but for a company added on the 1st March for example, the starting point should be 59 rather than 1 and so on. New companies added during the year need to use the current day of the year.

 

I can't find a way to store the current day of the year in a company record and then use that for any new companies. Any ideas?

0 Upvotes