Level 1 Model Building 2.0 (New UX) - Model Building Activity 5

LarysaK
LarysaK
in Academy Discussions

Team!

Pls help me, I can't move on.

EMP03 Employee Drivers by Role

image.png

EMP02 Employee Expenses - the task is update the formulas bonus, car , phone… to ref driver data in the EMP03; employees' costs to be driven by role and departent.
!!!!!!!!!!!!! I tried all possible scenarios, but I always get zero in the module EMP02 for any line items - bonus, car, phone.

Please exp what was the mistake. Thank you for your kind support.

image.png
image.png

Bonus formula

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

CarCost

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

SYS08 Employee Details

image.png

Answers

  • pyrypeura
    pyrypeura

    Hi,

    Could you check at individual employee level and utilise drill down. That way it can be easier to see what is going wrong. For example if the Employed? boolean is not working correctly. For example if you navigate to Shala Engle you should see 200 in Medical Costs row.

  • LarysaK
    LarysaK

    HI pyrypeura,

    The cell is empty. What is my problem? Please help. Thank you

    image.png

  • pyrypeura
    pyrypeura

    Could you show what dimensions you have in EMP03 from the blueprint? Your formula in EMP02 seems correct to me.

Categories