Forum Discussion

nk337's avatar
nk337
Copper Contributor
Dec 09, 2022

How can i use the if funtion for the changes ?

Hey everybody,

 

i want to calculate the %change and %point change from the Current year and period to the last year and period. How can i do this by using the IF Funtion or another function ?

 

excel
Formulas and Functions
training

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Dec 09, 2022

    Try:

    =LET(lastYr, XLOOKUP( ([@YEAR]-1)&[@[MTD/YTD]]&[@Period], [@YEAR]&[@[MTD/YTD]]&[@Period], [Sales(mEU)], 1), ([@[Sales(mEU)]]-lastYr)/lastYr)

Resources