Level 1 Model Building - Lesson 8.6.4

Hi Community

I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this would be greatly appreciated.

regards

Doc1_86372.docx

Accepted answers

Puneeth H P

Hi @NathanMay

Here in this for Revenue is 'REV02...'.Volume * 'REV01...'.Sales Price *(1 + Sales Price Growth %)

Here Sales price is increasing and is shown in Sales Price growth . So we need to capture Revenue with Sales Price Growth % .

Invalid error here may be because of some manual errors while selecting line items .

Hope the above condition helps you to solve this.

Thanks,

Puneeth HP

All comments

Puneeth H P

Hi @NathanMay

Here in this for Revenue is 'REV02...'.Volume * 'REV01...'.Sales Price *(1 + Sales Price Growth %)

Here Sales price is increasing and is shown in Sales Price growth . So we need to capture Revenue with Sales Price Growth % .

Invalid error here may be because of some manual errors while selecting line items .

Hope the above condition helps you to solve this.

Thanks,

Puneeth HP

NathanMay

Hi Puneeth Excellent thanks for your assistance and prompt response. regards

obkobby

I am also having the same issue and not able to fix it. i selected my line items very well yet, i am not able to put in the formula for revenue and cost of sales. Can you please help ?

Dijones128

Hello,

I've tried that formula you stated above, and it still does not work for me. Can someone assist me please.

Quick Links

Can you help?

Unanswered questions

3.3.12 Activity: Create Product Replenishment UX Page
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
How to represent in Anaplan an organizational structure
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?