Activity 5

bb21
bb21
in Academy Discussions

 

 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_0-1664445574538.png

 

 

Tagged:

Comments

  • jagadishdash
    jagadishdash

    @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,

Categories