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
Sure,
I am trying to divide 3 cube view rows at once:
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.