9.2.6 Activity: Add Formulas to Margin Calculation Module

Options

Hi

I have to enter this formula below and I don't understand this message :

"Circular references: Unit Cost Growth %, Cost of sale, Unit Price Growth %, Revenue, Cost of Sales, Margin, Margin % "

Can anyone help me please?

Cost of Sales

'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %)

Answers

  • Hi @Solene You're getting "circular references because REV02 Volume Inputs.Volume and the second condition is also getting referred from same module and second condition is related to the first one.

    Instead create a system module and use [sum or lookup] to refer.

    Thanks,

    Bishal

  • thanks