Medical Expenses Level 1


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


  • 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.



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

  • 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.