REV03 Margin Calculation Module_Formula _Lesson 8 and 9

Options
spawar
spawar Member, ALL USERS Posts: 2 New Contributor
in Anaplan Community

Hi,

In Lesson 8, for REV03 Margin Calculation Module, added the following line items and formulas.

 

Line Item Formula 

Revenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Price
Cost of Sales 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost
MarginRevenue - Cost of Sales
Margin %Margin/Revenue

 

But in Lesson-9: Price Growth Module, it is mentioned (in 9.2.6 Activity) to Open REV03 Margin Calculation module  and Add the formulas to the line items:

 
Revenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Price * (1 + Unit Price Growth %)
Cost of Sales'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %)
Unit Price Growth %IF 'SYS00 Time Settings'.Forecast Period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Unit Price %) ELSE 0
Unit Cost Growth % IF 'SYS00 Time Settings'.Forecast Period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Unit Cost %) ELSE 0

 

My Query - As we have already added formula in Lesson 8, if we again add formula (refer above grid) to Revenue and COGS in Lesson 9, will there be any discrepancy in previous Data which was derived.

 

Request your help regarding the above query,

 

Regards

spawar

 

Tagged:

Categories