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