Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
2 years ago

Additional math on GetDataCell expressions

I have a column performing the following expression: GetDataCell(Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct))):Name(PY % Var) The column uses the following formatting: ExcelNumberFormat = 0.0%, Excel...
Cube View
aformenti's avatar
aformenti
Icon for OneStream Employee rankOneStream Employee
2 years ago

Looking at the GetDataCell expression, is this accurate? Looks like you have a misplace braket:

GetDataCell((Divide(CVC(CYAct)-CVC(PYAct), CVC(PYAct)))*100):Name(PY % Var)

alternatively, you could try multiplying the numerator instead:

GetDataCell(Divide((CVC(CYAct)-CVC(PYAct))*100, CVC(PYAct))):Name(PY % Var)

 

 

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
2 years ago

Thank you, unfortunately either calculation still ignores the *100. May not be possible to apply  multiplication to CVMath.