Formula to track year over year revenue

Platform discussions
, , ,
1

I have a product membership that is purchased annually and renews automatically every calendar year. I’d like to track year over year revenue once the calendar year renews. Having trouble coming up with a formula to track this calculation.

Use Case:
Purchase Date 1/1/24
Purchase Price $100
Each year on Jan 1st the total revenue would increase by the purchase price of $100.

I’m guessing there would be a combination of a date automation and formula. I do use autoboost.
Thanks for the help and insight

2

@JRooney

See if this formula gives you what you are looking for:

INT(YEARFRAC(FORMAT_DATE({Purchase Date}), TODAY()) + 1) * {Purchase Price}

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

3

Thanks Jim - That looks like it does the trick. I have enjoyed watching your tutorial videos. I’m new at these formulas and having extra guidance definitely helps!