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