Level 1 exam Activity 5

vakalle
vakalle
edited November 18 in Modeling

I'm stuck on Level 1 exam model building exam Activity 5. I've spent over 2 hours and I'm frustrated. I've followed these steps and my solution is below with the updated formulas. Can someone offer any suggestions as these updated formulas result in the output being NIL/$0. I'd really appreciate it.

image.png

And my formulas now look like this….

Bonus IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Car Costs- IF Employed? THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Phone Costs- IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Medical Costs IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Answers

  • devrathahuja
    devrathahuja

    Hi @vakalle ,
    Can you also share snapshots of your modules?

    Additionally, can you verify if the employed boolean is showing a tick for employees? Do you have % populated for bonuses/other allowances?

Categories