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