Level 1 Exam Activity 4

afbedard
afbedard
in Modeling

I believe I have uploaded the EMP02 Employee Expenses and EMP03 Employee Drivers by Role correctly but when I go to change the formulas in EMP02 Employee Expenses for Bonus etc. I receive an error.

afbedard_1-1635262240866.png

afbedard_2-1635262269219.png

 

 

 

IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

afbedard_0-1635262174272.png

 

Tagged:

Answers

  • afbedard
    afbedard

    I was able to determine under SYS08 Employee Details under blueprint that my "Role" was not in the correct "Format" I had to change it from Text to List and then choosing the "List"

Categories