Medical Expenses Level 1

egmorale
egmorale
in Modeling

Can some tell me why I get 0 for the medical expenses? It doesn't give me an error message but just shows zero. I posted screenshots

 

I used this formula:

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

Tagged:

Comments

  • anand.shekhawat
    anand.shekhawat

    Hi @egmorale,

    You are perfectly right on your way. The reason you are getting 0 in the medical expenses is might because of the selected 'All Departments' in the page selector.

     

    Change it to any Employee and you will see the numbers flowing correctly.

     

    I hope it helps.

     

    ~Anand 

  • egmorale
    egmorale

    I changed it, but It still shows 0.  I'll add a screenshot with a more detailed page selection

  • anand.shekhawat
    anand.shekhawat

    Hi @egmorale ,

     

    If you are still getting zero, then kindly check the formula of 'Employed?' line item . It should be true to get the numbers from the EMP03 module. Also make sure your EMP03 and SYS08 module is populated correctly.

     

    ~Anand 

Categories