Skip to main content

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! 

 

 

Variance Formula

 

 

 

#Formulas

1 respuesta
  1. 17 feb 2025, 1:52 p.m.

    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