EMP02 Employee Expenses Formula is not working

Hi - I have been trying to calculate bonus, car, phone, and medical costs and the function i input gives me an error message. I am not sure what i am doing wrong. Can someone help me please?

Formula for Bonus:

Employed?

THEN

Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role]

ELSE

Thank you.

Screen_Shot_2022-07-16_at_1_142423.png

Comments

JaredDolich

@Melissaay

So close! This error is saying that your LOOKUP function is not using a list formatted line item. Double Check SYS08 and make sure department and role are LIST formatted. Department should be formatted to the department list and role should be formatted to the role list.

Format_142439.png

Melissaay

Hi @JaredDolich thank you so much!

I do not have the "Role" format listed - how do I add that one? Thank you so much! Please see attached.

Format_142439.png

JaredDolich

@Melissaay

Instead of TEXT select LIST then choose the "Role" list. Then you'll have a list formatted line item. When you use SUM and LOOKUP you must use a list formatted line item. You cannot use TEXT or NUMBER. If you're missing the "Role" list, you need to add it and load the roles. I believe this file is given to you in the exam.

Format_142439.png

Melissaay

@JaredDolich thank you so much! have a great one!

Format_142439.png

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…