Data flip sign when exporting to Excel
Dear community,
We encountered a reporting issue: when exporting a cube view to Excel, one line of data will flip the signage.
In cube view, we have the Budget amount of (10,763), and the delta...
Forum Discussion
Hi Jack,
Thank you for sharing the idea!
I re-created the cube view and found what was causing the issue.
Next to the delta column, we have another delta% column, in which the formula is: GetDataCell(CVC(delta)/ ABS(CVC(budget))).
As soon as the ABS function is added, the data in the budget column flips, but I cannot understand why this would occur.
Do you have any ideas of such behavior when using the ABS function?
Thank you!