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 |
Answers
-
Hi @Venki9902,
Any update on this? I have the same issue. My EMP03 is properly imported. SYS08 is properly Role is formatted as List..
0