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

[kebe]

this is the formula 

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

[rishabh01 · Accepted solution]

Hey @kebe 

Make sure that item you are referencing in your lookup is list formatted. Currently, it is text formatted I believe.

Thanks, 

Rishabh.

[kebe]

you are right, i formatted the role as text while it was a list

[rishabh01 · Accepted solution]

Great! You can accept the solution if it worked.