CAGR calculation

[ford]

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

[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