How to calculate the YoY growth in line item

HPunuru

I have Year wise numbers in my line item in a module, now i want to calculate the Year by year growth in between years.

I want to calculate FY21 YoY = FY21 Productivity growth / Fy20 Productivity Growth.

 

FY21 YoY= 2.55%

 

Please suggest me how get the result.

ChrisStauffer

This solution may help

 

https://community.anaplan.com/t5/Anaplan-Platform/Year-over-Year-Growth/m-p/679#M3195

 

 

ManjunathKN

Hi,

Please try the below formula.

(1-(FY21 Productivity growth/previous(Fy20 Productivity Growth)))*100

Hope this helps
Thanks,
Manjunath

ManjunathKN

Do not multiple by 100 if you want to use % as your number format

Thanks,
Manjunath