Cube View Math Division

Question

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?&nbsp; If not, is there another solution?

Pete · Answer

Seems like you'd need to do GetDataCell(Divide(Divide(CVR(Subtotal_BOPConvCost), CVR(Subtotal_CasterYield)),CVR(Subtotal_HSMYield)))

Sabaritha · Answer

Hello,Could you please provide the formula (sample formula with the sample rows)? Will be able to help you.&nbsp;The error message says that the formula might be missing a parenthesis. This can be fixed.Thank you.

mjoneill · Answer

Sure,
I am trying to divide 3 cube view rows at once:

&nbsp;

Sabaritha · Answer

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).

mjoneill · Answer

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.&nbsp;

Forum Discussion

Cube View Math Division

Related Content

Cube View Cell Formatting / Division to 1000

Cube Views

Cube View Groups

Row Division Formula

Cube View Profiles