Hi All,
I am trying to calculate the Compound annual growth rate (CAGR) in Anaplan and I am getting a 100% instead of 1%.
Here is the formula logic in excel =((Z84/C84)^(1/23)-1)
The first value is cell=(C84) January 2021 value = -167,217
The last value is cell=(Z84) December 2022 value = -136,485
The Cost values go across January 2021 - December 2022
In Anaplan used this logic :-
End Value = December 2022 value = -136,485
Starting Value = January 2021 value = -167,217
BB CAGR = POWER(End Value / Starting Value, 1 / 23) - 1
In Excel it resolve to -1% throughout the line item which is expected, but in Anaplan I get -1 but when I format the to percentage then it changes to -100%.
Please does anyone knows why it does that and how can I make it to show -1% instead of -100%. Please this is urgent for me, any help will be appreciated.
Number format
But when formatted to percentage, it shows -100% instead of -1%