Forum Discussion

michaelkeung's avatar
michaelkeung
New Contributor III
2 years ago

Cubeview CVR CVC calculation error

Hi, I have a cue view report of below settings: Net Sales row: A#NS Std cost row: A#SC gross Margin row: GetDataCell(A#NS - A#SC):Name("GROSS MARGIN") Col1: S#Budget Col2: S#RollingBud Col...
Cube View
Manasa's avatar
Manasa
New Contributor III
2 years ago

Hi,

Since you already have a getdatacell in your columns, the GetDataCell(A#NS - A#SC) is overriding your CVC's giving you the wrong value. Could you please try GetDataCell(CVR(Net Sales row) - CVR(Std cost row)) instead.

Thanks.

  • michaelkeung's avatar
    michaelkeung
    New Contributor III
    2 years ago

    Thank you for your reply.

    But in some reports, I don't want to show NS and SC lines nor I don't want to create new accounts, I want to directly use A#NS - A#SC . Is there a way to do that?

     

    • Manasa's avatar
      Manasa
      New Contributor III
      2 years ago

      For those, you can place two column overrides in your gross margin row, one for variances and the other for variances%, and mention the CVC formulae so that it picks up the relevant getdatacell.

      • michaelkeung's avatar
        michaelkeung
        New Contributor III
        2 years ago

        I can only place 4 overrides and my reports have more than that.
        Why cannot the system calculate under such situation?