Skip to main content
L
Leasa
Newcomer
June 9, 2022
Solved

Power Formulas in Cube Views / Dimension Formulas / Business Rules?

  • June 9, 2022
  • 1 reply
  • 0 views

We'd like to calculate CAGR in cube views, is there a formula to use in the cube views? If there are formulas that only work for dimension members and business rules I'm also happy to hear, then link to the cube views.

I already tried "POWER(x,y)" and "x^(1/y)" and they don't work.

Thank you in advance!

Best answer by NidhiMangtani

Hello, please use Math.Pow(x,y) to handle this inside a Member formula or Business Rule.

 

result = Math.Pow(x, y)
x, y

Data Type: Double

Return Value

A Double that is x (the base) raised to the power y (the exponent)

We had implemented complex statistical calculations using this function to handle power calculations.

Hope this helps.

1 reply

N
NidhiMangtaniAnswer
Veteran
June 9, 2022

Hello, please use Math.Pow(x,y) to handle this inside a Member formula or Business Rule.

 

result = Math.Pow(x, y)
x, y

Data Type: Double

Return Value

A Double that is x (the base) raised to the power y (the exponent)

We had implemented complex statistical calculations using this function to handle power calculations.

Hope this helps.

    L
    LeasaAuthor
    Newcomer
    June 9, 2022

    This indeed works! 

    Thank you very much Bharti!

    Regards,

    Leasa

    Terms & ConditionsAccessibility statement