L1MB Activity 5

Hi Team,

Looking for some guidance on L1MB Activity 5. I built the following code:

IF Employed? THEN Salary * 'EMPO3 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOKUP: 'SYSO8 Employee Details'.Role] ELSE 0

But get the following error message:

"Automatic sum of 'EMPO3 Employee Drivers By Role'.Bonus % over E3 Role hierarchy is not possible as E3 Role does not have a built-in top level."

Does this have to do with my general list Top Level and Parent Hierarchy? Attaching image.

I appreciate the guidance in advance.

Capture_1_128161.PNG

Accepted answers

All comments

ChrisAHeathcote

@ahenry

The formula is trying g to find the sum of all roles as there is no valid mapping.

Check the role line item in the systems module to make sure it is list formatted. I suspect its formatted as Text.

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…