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 September 2026 official release notes. There you'll find information on: User Experience KPI cards Mobile Zoom and pan KPI Conditional formatting Intelligence CoModeler Analyst Optimizer Disclosure Management Refreshed user interface Anaplan Data…
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…
