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
One should try to do all calculations inside the calculation (eh) engine, to avoid problems. If GetDataCell(S#Actual - S#Budget) is a positive 700, I would use that calculation rather than going through CVC, because that number is more likely to be correct and you have more control over the POV.
More specifically, I have a feeling there are stray Override formattings kicking in. If I were you, I'd rebuild the CV from scratch, one column at a time, keeping in mind the above-mentioned principle; once numbers look good, only then apply the minimum amount of formatting you absolutely need. The first rule of troubleshooting is isolating components; so isolate numbers (by putting them together without formatting rules), and only move on once you know they look ok.