Hello all,
I'm trying to translate a cagr calculation to cognos syntax and am having a bit of a problem with the exponential function - exp().
Here's the calculation I'm trying to translate:
(([Spring2010]/[Spring2007])^(1/3)-1)
Any and all help would be appreciated. Even a cut and paste expression of anyone's using the exp() function would be a benifit.
Thanks.
Ford
for anyone interested in the solution:
power(
([Business View].[US Customer Growth Strategy Plan].[S10F]/[Business View].[US Customer Growth Strategy Plan].[S05]), (1/5)
)-1
/[Business View].[US Customer Growth Strategy Plan].[S05])-1