Compound Average Growth Rate

[ozbroomy]

I am trying to get the equivalent Compound Annual Growth Rate calculation from excel to return the same results in cognos.

My example uses the following data
2012 - 1819
2013 - 1787
2014 - 1793
2015 - 1826
2016 - 1875
2017 - 1891

In excel this formala: (2017 value / 2012 value) ^ (1/5)-1
Gives a result of 0.777% CAGR

Inspired by the suggestion\calculation suggested here - http://www.cognoise.com/community/index.php?topic=2642.0
I am using a query expression like this: power([2017] / [2012]), (1/5))-1
but my result is different: 0.666% CAGR

Any suggestions would be greatly appreciated
Ozbroomy

[RKMI]

Hi OZ,

This is what I tried I created a simple query added the following Data Item 1 with value of 2017 = 1891, Data Item 2 with value of 2012 = 1819 and Data Item 3 = power (([Data Item1]/[Data Item2]),(1/5))-1. The result was .779%

Here is the formula your trying power (([2017]/[2015]),(1/5))-1. My guess is your brackets or values were off when you tried you calc.

Thanks,
RK