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
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.
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