Level 1 Exam - Question 5

[lcapon]

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

[JaredDolich]

@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

[lcapon]

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

[lcapon]

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!!!

[JaredDolich]

@lcapon 

Bingo! Nice job. You got this!

[varungantasala]

Can You please tell me how