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

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

Accepted answers

All comments

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

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

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

it worked, thank you so much

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…