Level 1 Lesson 11.3.4

I have been stuck on the first formula for days. When I enter it the error I get is:

I'm not sure what this means, I have gone back and double checked the naming of all of my modules and made sure I was typing the formula correctly:

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

I've tried typing it, copying it, no matter what I do it won't work. If someone could provide some guidance I would really appreciate it.

Accepted answers

rob_marshall

@JBeauchs

Basically, you are trying to accomplish a calculation that you are wanting to do sum of data on and the calculation can't do it. Usually, this means you are missing a Top Level member of a list (which is used to get a total of that list).

For example, if I have a list of Employee's without a top member,

Rob

Mark

Jeff

George

Well, there is nothing at the top to sum that data. To fix that, put in.a top level member in the Configure tab of the list
All Employees

Rob

Mark

Jeff

George

JBeauchs

Thanks for the response. I had entered the wrong information in EMP02 and had to go back and correct my error to get the formula to work.

All comments

rob_marshall

@JBeauchs

For example, if I have a list of Employee's without a top member,

Rob

Mark

Jeff

George

Well, there is nothing at the top to sum that data. To fix that, put in.a top level member in the Configure tab of the list
All Employees

Rob

Mark

Jeff

George

JBeauchs

Thanks for the response. I had entered the wrong information in EMP02 and had to go back and correct my error to get the formula to work.

AnnieMa

I was wondering if anyone could provide me with a breakdown of what these formulas are saying or actually telling the computer? - like what is this formula trying to achieve?

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
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…