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.

  • Yogendrsingh5july
    Yogendrsingh5july

    Hi @einas.ibrahim

    in L1 9.2.6 while adding the formula to the rev03 margin calculation module, this is the error i am getting ,

    kindly help

    image.png

  • seymatas1
    seymatas1

    Hi @Yogendrsingh5july
    To help troubleshoot this error, check your SYS00 Time Settings module and see if Forecast Period? line item is there.

    I hope this helps.

    Seyma 🌷🙂

  • Yogendrsingh5july
    Yogendrsingh5july

    it worked, thank you so much

Categories