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!