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.
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:
Can someone please pinpoint exactly what I need to do to fix this?