Level 1 - Activity 5

Annika

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

Venki9902

Hi @Annika ,

Formulas are seems to be correct, did you check the data in the EMP03 module for other line items?

Regards,
Venkatesh

iamgel09

Hi @Venki9902,

Any update on this? I have the same issue. My EMP03 is properly imported. SYS08 is properly Role is formatted as List..