Forum Discussion

mjoneill's avatar
mjoneill
New Contributor II
2 months ago

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?
Cube View
Reports
mjoneill's avatar
mjoneill
New Contributor II
2 months ago

Sure,

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

 

Pete's avatar
Pete
New Contributor III
2 months ago

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