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