LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation_ Error

ankulkarni
ankulkarni
in Modeling

The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help 

ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is not a recognized line item or list member

 

line item- Revenue

Formula - 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price

Line Item- Cost of Sales

Formula- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs

Tagged:

Answers

  • einas.ibrahim
    einas.ibrahim

    Hi @ankulkarni 

     

    1. Make sure that you copy the names of modules and line items you are asked to create directly from the training material into your models.
    2. Instead of typing the formulas, try to point to the line items you want to reference in other modules. This ensures no typos and single quotes are included when necessary. For example the name of the module ‘REV02 Volume Inputs’ should be placed between single quotes since it includes special character -numbers or symbols.

Categories