Level 1 - Activity 5
In EMP02,The line item, Bonus has been populated but I am getting 0 for car costs, phone costs and medical costs.
here are the formulas used,
IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus%[LOOKUP: 'SYS08 Employee Details'.Department | LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 |
---|---|
IF Employed? THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department | LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 |
IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department | LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 |
IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department | LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 |