Level 1 , Activity 5

MarufaKamal
New Contributor

Level 1 , Activity 5

I have mapped everything right in level 1 activity 5 , 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 .I have attached my mapping here.

1 REPLY 1
Akhtar.shahbaz
Community Boss

Hi @MarufaKamal ,

 

Your 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 this helps

Thanks

Akhtar