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 August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…