I tried to update the formulas but it shows Invalid fomula .
Updated formulas for Bonus was below,
IF Employed? THEN Salary * 'EMP 03 Employee Drivers by Role.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0
What exactly am I doing wrong here? Any help would be greatly appreciated.
Go to Solution.
Hi, if you haven't spotted it already the SYS08 lookup should be to Role not Country
Thank you for your advice and I tryed it again but still error.
The formula for 'EMP02 Employee Expenses'.Bonus is invalid:Bonus = IF Employed? THEN Salary * EMP03 Employee Drivers by Role''.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
Hi, you're right. I didn't spot it. The single quotes here. (and previously there was only a quote at the start of the module name)EMP03 Employee Drivers by Role''What I would do when I can't spot it, I copy one I know is working and modify it!
I solved this issue! Thank you very much!