level 1  Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line

0 Kudos

level 1  Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line

level 1 

Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. 

Open the REV03 Margin Calculation module. 

Toggle to blueprint view to enter the following formulas for each line item: 

 

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

Current formula:- Revenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price * (1 + Sales Price Growth %)

Correct Formula:- Revenue'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %)

 

Current Formula:- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %)

Correct Formula:- 'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %)

1 Comment
Community Manager
 
Status changed to: Your support is needed
Users Online
Currently online: 262 members 614 guests
Please welcome our newest community members: