The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
DRider
OneStream Employee
OneStream EmployeeAdditional 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...
aformentiOneStream Employee
OneStream EmployeeHI 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.
DRiderOneStream Employee
OneStream EmployeeThanks for the reply. Unfortunately scale won't work because I need the number to become larger.
My scale is set to 0 right now (to override other scale settings in the cube view), and that is the only way for the proper number to appear in the OneStream view. If I change the scale, it won't appear correctly within the OneStream view.
If I could apply a scale to the Excel view and no scale to the OneStream view, that would accomplish the objective, but I don't believe it's possible.
- KarlT
Have you tried setting the ExcelUseScale to false for that row/column to see if that solves it?
- DRider
If set to false, it defaults to scale = 0 and doesn't change since scale is set to 0 in the column formatting..
- aformenti
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
Thank you, unfortunately either calculation still ignores the *100. May not be possible to apply multiplication to CVMath.