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(Row...
Cube View
Dashboards
Reports
Pete's avatar
Pete
New Contributor III

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
14 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