Skip to main content
M
michaelkeung
November 21, 2023

Cubeview CVR CVC calculation error

  • November 21, 2023
  • 1 reply
  • 0 views

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

Col3: GetDataCell(CVC(Col1) - CVC(Col2)):Name("VARIANCES")
Col4:GetDataCell((CVC(Col1) - CVC(Col2))/CVC(Col2)):Name("VARIANCES%")

BUT you can see below the col3 and col4 for the gross margin cell has a wrong calculation.
It should be 335501-1736404 = -1400903 but it shows +1080805.

May I know why there is error and how to fix it?

Thank you.


a.PNG

1 reply

M
Manasa
November 21, 2023

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.

M
michaelkeungAuthor
November 23, 2023

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?

 

M
Manasa
November 23, 2023

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.

Terms & ConditionsAccessibility statement