Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module

I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount.

REP03 Profit & Loss Headcount FormulaError message displayed for the formula

Further, I would like to know whether the formula repeats itself for all the line items when you enter a formula for the Headcount in one country? Appreciate some help.

Accepted answers

All comments

Misbah

@ThiruT

See the error in red: Country Code is a text, you can't use SUM on text formatted line items

Your Formula: IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country Code] ELSE 'DATA01 P&L Actuals and Budget'.Headcount

Expected formula: IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actuals and Budget'.Headcount

Second Question: Yes, it will automatically calculate for each country in that particular line item as Formula is line item specific.

Hope that helps

Misbah

ThiruT

Hi Isn't country text too?

Sumair

There may be some Problem in Module creation since it might differ little bit to that formula given and hence You are encountering the error..

You Can follow this step , it worked for me

Follow the syntax and dont blindly copy formula from learning...

Example (Here is the formula given in learning): IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and Budget'.Headcount

Instead the alternate way is following this step if encountered error

IF(First Type this ) 'SYS09 Version Details'.Forecast?(Here in this,locate this in the module and this automatically gets added to the formula ) THEN (type this) 'EMP02 Employee Expenses'.Headcount(Locate this in module and this adds up in the formula)

Follow this step in the entire formula...Use the proper syntax and locate module ..

Hope this helps , Cheers !!!

bogirere

In jan20 in my model i am getting negative values i don't know where i got the wrong

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…