Forum Discussion

Leasa's avatar
Leasa
New Contributor II
3 years ago

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

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!

Cube View
  • NidhiMangtani's avatar
    NidhiMangtani
    3 years ago

    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.

  • NidhiMangtani's avatar
    NidhiMangtani
    Contributor III
    3 years ago

    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.

    • Leasa's avatar
      Leasa
      New Contributor II
      3 years ago

      This indeed works! 

      Thank you very much Bharti!

      Regards,

      Leasa

      • NidhiMangtani's avatar
        NidhiMangtani
        Contributor III
        3 years ago

        Hello Pahul,

        Please quantify your requirement a bit for me, raise by 10%, 20%, x%, etc would be simple multiplication using CVR/CVC formula.