CAGR Formula Issue

innocent

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

Himanshu1998

@innocent You need to use "Power" function as Anaplan does not support "^" this sign. You can learn more about Power function from anapedia.

skarki

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.

innocent

@Himanshu1998 Thanks for the response, do you have any example for the formula

Himanshu1998

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!!

innocent

Thanks @skarki and @Himanshu1998