Forum Discussion

DDrider's avatar
DDrider
New Contributor III
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
DDrider's avatar
DDrider
New Contributor III
2 years ago

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.

KarlT's avatar
KarlT
Contributor III
2 years ago

Have you tried setting the ExcelUseScale to false for that row/column to see if that solves it?

  • DDrider's avatar
    DDrider
    New Contributor III
    2 years ago

    If set to false, it defaults to scale = 0 and doesn't change since scale is set to 0 in the column formatting..