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

kebe
Occasional Contributor

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

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
rishabh01
Frequent Contributor

Hey @kebe 

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

Thanks, 

Rishabh.

View solution in original post

rishabh01
Frequent Contributor

Great! You can accept the solution if it worked.

View solution in original post

3 REPLIES 3
rishabh01
Frequent Contributor

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

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

rishabh01
Frequent Contributor

Great! You can accept the solution if it worked.