06-09-2022 07:31 AM - last edited on 05-19-2023 11:04 AM by JackLacava
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!
Solved! Go to Solution.
06-09-2022 09:06 AM
Hello, please use Math.Pow(x,y) to handle this inside a Member formula or Business Rule.
result = Math.Pow(x, y)
Data Type: Double
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.
06-09-2022 09:06 AM
Hello, please use Math.Pow(x,y) to handle this inside a Member formula or Business Rule.
result = Math.Pow(x, y)
Data Type: Double
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.
06-09-2022 03:56 PM
This indeed works!
Thank you very much Bharti!
Regards,
Leasa
07-25-2022 07:04 AM - edited 07-25-2022 07:08 AM
@NidhiMangtani - Do you know a way to give raise in CV's? in GetDataCells?
07-25-2022 07:08 AM
Hello Pahul,
Please quantify your requirement a bit for me, raise by 10%, 20%, x%, etc would be simple multiplication using CVR/CVC formula.
07-25-2022 07:11 AM
Its like 2^3 or 3^3 in VB
07-25-2022 09:14 AM
Hi Pahul,
As per my understanding, Onestream does not interpret '^' symbol as exponent calculation like we use in VB.Net so we resorted to using Math.Pow(a,b). For using the same in CVs, you can have dynamic calc accounts which internally have exponent computation using Math.Pow(a,b).
Hope this helps.