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 November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…