Forum Discussion

Sergey's avatar
Sergey
Contributor III
3 years ago

Implementating a CAGR calculation in cube view

Dear community,

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

Cube View
  • Sergey's avatar
    Sergey
    Contributor III
    3 years ago

    Hi Chris,

    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 ?

    Regards,

    Cyril