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

HI DRider ,

Have you tried using the Scale formatting option? since you have ExcelUseScale=TRUE, setting the right scale might do the trick instead of having to Multiply the GetDataCell() result.