Medical Expenses Level 1

egmorale
Occasional Contributor

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

3 REPLIES 3
anand.shekhawat
Frequent Contributor

Re: Medical Expenses Level 1

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
Occasional Contributor

Re: Medical Expenses Level 1

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

anand.shekhawat
Frequent Contributor

Re: Medical Expenses Level 1

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