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...
Forum Discussion
HI DDrider ,
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.
Thanks 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.
Have you tried setting the ExcelUseScale to false for that row/column to see if that solves it?
If set to false, it defaults to scale = 0 and doesn't change since scale is set to 0 in the column formatting..
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)Thank you, unfortunately either calculation still ignores the *100. May not be possible to apply multiplication to CVMath.
