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