Level 1 Exam - Question 5

I dont know where i'm going wrong.....this is the formula I'm trying to use....


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

Tagged:

Comments

  • @lcapon 

    So close! Try removing the double quote. So, so close.

    Correct:

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

    Yours

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

  • Thank you for getting back to me so quickly - unfortunately I now get.....this error....

    Data type mismatch: format other than LIST or DATE being referenced as a relation

  • So i just realised that the newly added 'role' hadnt been setup as a list - so I have gone back and updated and reimported :-0) 

     

     

    Its working!!!

  • @lcapon 

    Bingo! Nice job. You got this!

  • Can You please tell me how

  • receving the same error

     

    Data type mismatch: format other than LIST or DATE being referenced as a relation

  • Carlos3k
    edited May 2023

    I am entering the correct formula and I am still getting all zeroes in my data. Can someone please help?