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


  • Hey @kebe 

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



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

  • Great! You can accept the solution if it worked.