this is the formula
IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0
Go to Solution.
Make sure that item you are referencing in your lookup is list formatted. Currently, it is text formatted I believe.
View solution in original post
you are right, i formatted the role as text while it was a list