Level 1 - Activity 5

Annika
Annika
in Academy Discussions

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

Screenshot (10).png

Answers

  • Venki9902
    Venki9902
    edited June 23

    Hi @Annika ,

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

    Regards,
    Venkatesh

Categories