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'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
DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
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
Icon for OneStream Employee rankOneStream Employee
2 years ago

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

  • DRider's avatar
    DRider
    Icon for OneStream Employee rankOneStream Employee
    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..