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,
Anaplan's next quarterly platform release webinar will be held January 29, 2026 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…
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…