L1 Exam Activity 5 - Stuck for a Week, Spinning Wheels

Hi all -

I have been stuck on the L1 Exam Activity 5 for over a week now and the 'hints' have not been helpful at all. I have been spinning my wheels and do not know where I am going wrong. ACTIVITY 5.png

This is the formula I used for bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'EMP03 Employee Drivers by Role'.Department, LOOKUP: 'EMP03 Employee Drivers by Role'.Role] ELSE 0

And I keep getting a message that says it is invalid: The name 'EMP03 Employee Drivers by Role'.Department used in the LOOKUP clause is not recognized as a line item in the model

This is what I have for EMP03 Employee Drivers by Role where you can see the Department and Role at the top:

Screen Shot 2022-03-15 at 5.05.48 PM.png

Can someone please pinpoint exactly what I need to do to fix this?

Comments

TimothyThomas

Hi @tspoon ,

I think you need to be referencing a Systems module in your lookups rather than the EMP03 module. You should have a systems module for Employee Details that is dimensionalized by just #E2 Employees (mine is SYS08, not sure if yours is the same number). You're going to want to look up the role from this module, though maybe something other than department for the other lookup...

Let me know if that helps at all!

Thanks,

Timmy

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…