Level 1 Exam Activity 6 - Incorrect Value

I have got as far as Activity 6 and added in formulas to pull data into REP004 but the values are incorrect, Medical costs should be 24000 but I have 36000 so not sure what I ve done wrong and how or what to correct. Might be the format and need to pivot differently but I ve come to a complete halt and failed as I was unable to move forward.

Any suggestions on how to correct and move forward would be appreciated

Answers

  • @andyevans594 - Check the mappings for employees (Country, department), the % for medical/insurance/etc as well.

  • Thanks, I had a wrong field on one of the calculations which I didn't spot. Once I had made this change worked OK. Passed level 1 , now onto level 2