03-09-2023 12:58 AM - last edited Tuesday by JackLacava
I am trying to implement a CAGR calculation as shown in this link : https://blog.hubspot.com/marketing/cagr-formula-excel
I have 3 years of data in a cube view, hence my calc should be : (end value / beg value) ^ (1/3) - 1
However, OneStrea does not recognize this "^" which is a pity. What are the alternative to define an exponential value in the cube view ?
What I currently have :
GetDataCell( (CVC(end_value) / CVC(beg_value) ) ^ (1-3) -1 ):NAME(CAGR)
Many thanks for your input on this
03-09-2023 05:30 AM
Could this not be done using a DynamicCalc member?
DynamicCalc just retrieves the corresponding end_value & beg_value using GetDataCell, into two numeric variables.
And then do the math (where you have the Math.Pow function : https://learn.microsoft.com/en-us/dotnet/api/system.math.pow?view=net-7.0 )
03-09-2023 06:51 AM
I understand the logic, but this indicator will be applied to several indicators, scenario & years, so I don't clearly see how we can use a dynamicCalc member in this situation.
If I use a business rule in a cube view, is there a way to reference previous columns of a given cube view ?