Level 1 Exam - Question 5

lcapon
Frequent Contributor

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

4 REPLIES 4
JaredDolich
Moderator

Re: Level 1 Exam - Question 5

@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


Jared Dolich
lcapon
Frequent Contributor

Re: Level 1 Exam - Question 5

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
Frequent Contributor

Re: Level 1 Exam - Question 5

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
Moderator

Re: Level 1 Exam - Question 5

@lcapon 

Bingo! Nice job. You got this!


Jared Dolich