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

  • Venki9902
    edited June 2023

    Hi @Annika ,

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

    Regards,
    Venkatesh

  • Hi @Venki9902,

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