Cube View Math Division
Hi all,
I am trying to divide 3 different rows in one Getdatacell formula and I am getting an error saying this:
Is this even possible? If not, is there another solution?
Forum Discussion
Hello,
Could you please provide the formula (sample formula with the sample rows)? Will be able to help you.
The error message says that the formula might be missing a parenthesis. This can be fixed.
Thank you.
Sure,
I am trying to divide 3 cube view rows at once:
Seems like you'd need to do GetDataCell(Divide(Divide(CVR(Subtotal_BOPConvCost), CVR(Subtotal_CasterYield)),CVR(Subtotal_HSMYield)))
Hello,
Could you please send me the actual calculation like in math terms so that I can tell you whether it is possible?
In the divide function, the first term is the numerator, and the second term is the denominator. But I see three terms here in the calculation. A/B = Divide(A, B).
Yes, I am trying to divide a price divided by a yield and then another yield (these are already current rows in my cube view) ... For example:
$50 / .90 / .85 = 65.36
I am trying to do this with all-in-one member filter so i don't need to show the result of 50 / .90 and then the result of 55.56 /.85 in another to get my answer.
