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 Item | Formula |
| 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 %)
Comments
-
Status changed to: New0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!