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
Comments
-
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
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 relation0 -
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!!!
0 -
Bingo! Nice job. You got this!
0 -
Can You please tell me how
0 -
receving the same error
Data type mismatch: format other than LIST or DATE being referenced as a relation
0 -
I am entering the correct formula and I am still getting all zeroes in my data. Can someone please help?
0