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



I'm trying to this formula for the bonus line item and I'm getting an error message.


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


Can I have some help on what is wrong? Thank you! 

Screen Shot 2022-04-11 at 8.51.52 AM.png




  • Hi @ShawnaM 


    Kindly check the format of the 'Department' and 'Country' line item in the SYS08 Employee Details Module. Both should be List formatted as you are using a LOOKUP upon them.