9.2.6 Activity: Add Formulas to Margin Calculation Module

Solene
Solene
in Academy Discussions

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

  • Bishalpilley
    Bishalpilley

    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

  • Solene
    Solene

    thanks

Categories