I have mapped everything right , but the medical cost for December 2020 is showing 36,800 and that is not the right answer.
Can anyone please help me with ,
where I am making the mistake .
@bb21
EMP03 Driver by role module has Employee & Role as dimensions but you have written your formula to lookup the department only,
you have to add 1 more lookup for Roles
'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role]
Hope it helpful for you. If it is please accept my answer as solutions.
Thanks,
Check out the latest Anaplan feature updates and enhancements in our March 2026 official release notes. There you'll find information on: Intelligence Anaplan CoModeler Anaplan Analyst Anaplan Agent Studio User Experience Data driven hierarchies with drag-and-drop Enable or disable comments Module-driven navigation actions…
Check out the latest Anaplan feature updates and enhancements in our February 2026 official release notes. There you'll find information on: User Experience Board Insights Panel Management Reporting on mobile Custom action buttons on mobile Modeling experience Four digit calendar Forecaster Holiday calendars UX pages…
