CAGR Formula Issue
Hi,
I would like to write a CAGR formula in Anaplan and don't know how to go about it.
Below is the formula.
(Ending Value/Beginning Value) ^ (1/No. of Periods) – 1
Each time I try this formula Anaplan throws an error invalid formula. It seems Anaplan does not recognize this ^ sign.
Please any workaround or suggestion how to go about this?
Thanks
Best Answers
-
@innocent You need to use "Power" function as Anaplan does not support "^" this sign. You can learn more about Power function from anapedia.
0 -
I believe you could use (Power((Ending Value/Beginning Value),(1/No. of Periods) ) -1). May be you could create two separate line items and use them inside power function to simplify calculation.
0
Answers
-
@Himanshu1998 Thanks for the response, do you have any example for the formula
0 -
Hi @innocent
If I need to calculate 10^2, then in Anaplan I would use Power(10,2) to achieve this.
You can use the formula which Skarki has written to solve your problem.
Cheers!!
0 -
Thanks @skarki and @Himanshu1998
0