Hi everyone,
I need to create a formula to calculate the variance between Sponsorship Amount in 2024 and Sponsorship Amount in 2025, any insight? I'm new to formulas and am a little stuck.
Any help is much appreciated!
#Formulas
1 Antwort
Hi Arianna,
There's actually quite a good article for YOY comparison here:
https://help.salesforce.com/s/articleView?id=000387764&type=1( AMOUNT:SUM - PREVGROUPVAL(AMOUNT:SUM, YourDateGrouping)) /
PREVGROUPVAL(AMOUNT:SUM, YourDateGrouping)
You will need to adapt by changing the field names (by selecting them in the left hand side panel), but it's the exact same principle