Forum Discussion

Jacky_C's avatar
Jacky_C
New Contributor III
16 days ago

ABS function in GetDataCell formula

Hi all,

We encountered an issue with the ABS function in a GetDataCell formula. Our cube view has two rows: the first tagged to account A#100, and the second with the formula GetDataCell(ABS(CVR(Row1))). The data displays correctly in the data explorer, but when using ‘Show Report’ or ‘Export to Excel,’ both rows show the absolute value of the original amount, which is not the expected output. An example is provided below

Data explorer view (correct amount)

Row NameMember FilterOutput
Row1A#100$ -1,000
ABS_Row1GetDataCell(ABS(CVR(Row1))$ 1,000

 

Show Report/Export to Excel view (incorrect amount)

Row NameMember FilterOutput
Row1A#100$ 1,000
ABS_Row1GetDataCell(ABS(CVR(Row1))$ 1,000

 

Does anyone know whether this is an issue in OneStream? Thank you.

Best,

Jacky

Cube View
Dashboards
Reports
  • Pete's avatar
    Pete
    New Contributor III
    16 days ago

    I tried recreating something similar to this, and I couldn't get the Cube View to do what yours is doing when I used the GetDataCell(ABS(CVR(Row1)). When I did this, both rows populated with the same value. I had to use GetDataCell(ABS(A#100)) for it to work, this may fix your issue. 

    When it comes to the Report/Excel options, it could possibly be due to your formatting for the Report and Excel versions. If that red is coming across, that is depicting the negative value instead of using () or a - sign. You could update this in the Cube View Properties Cell format, or in the ABS_Row1 cell format. 

    • Jacky_C's avatar
      Jacky_C
      New Contributor III
      13 days ago

      Hi Pete, 

      Thanks for your reply. I tried using GetDataCell(ABS(A#100)), and the value displays correctly. We could revamp our cube views to fix this, but we still want to understand why the ABS function doesn’t work as expected in Show Report/Export to Excel view.

      Thank you.

      Best,

      Jacky