Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
1 year 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
Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hi, are you using the same user culture in OneStream and in Excel? Seems like in OS, the "." is used as a decimal point, whereas Excel interprets it as a thousand separator (as is common e.g. in Europe).

You could just add a linked CV which is formatted correctly to be opened in Excel instead of the original one such as "VC_001_ExcelOpen" in case neither of the above suggestions work out for you.