Level 1 modal building exam medical costs




I’m attempting the question to update the formula for pulling allowances from SYS08 module. However I got the error “data type mismatch. Format other than LIST or DATE being referenced as a relation”


may I know what does that mean?


the formula I have keyed is:

IF Employed? THEN Salary * EMP03 Employee Drivers by Role’.Bonus Percentage [Lookup: SYS08 Employee Details’.Department, Lookup: SYS08 Employee Details’.Role] ELSE 0



  • @Zhiying 


    Can you share the screen shot of SYS08 module , you need to use Employees role and department as look up reference - your formula looks correct though ,just ensure your sys08 module is correct.

  • Hi, 


    I have figured out. I would need to change the format of roles to list. previously i was not able to do so as i did not remove the modules that were linked to it. after deleting the linked modules, i was able to format the roles of list