Questions about Cube Views and Reports

Forum Posts

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 is calculated with GetDataCell(CVC(Actual column) - CVC(...

LisaC_0-1708898772073.png LisaC_1-1708898981900.png
LisaC by New Contributor II
  • 3 replies
  • 1 kudos

Resolved! Cube View Cell Conditional Formatting - Large % result

I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm"). Can anyone provide the conditional formatting text that would replace the actual % variance with tex...

kglen by New Contributor
  • 2 replies
  • 0 kudos

Resolved! cube view formatting

I want format the Cube view cell based on cell amountIf (CellAmount > GetDataCell(CVC(Col2)) )ThenBackgroundColor = Red, TextColor = WhiteEnd if This code is not working, Actually I am comparing actual amount with budget. how can we do this?