L1 Exam - Activity 5 and Questions 4 and 5

NoAmazonAffiliation
NoAmazonAffiliation
in Academy Discussions

I finally got the formulas valid for Activity 5, but now the only values I'm seeing in Bonus %, Car Costs, Phone Costs, and Medical Costs is 0.

 

NoAmazonAffiliation_1-1652647357924.png

NoAmazonAffiliation_2-1652647464235.png

NoAmazonAffiliation_3-1652647582838.png

Can someone tell me what I'm missing?

Thanks in advance!

Comments

  • BrunoRodriguez
    BrunoRodriguez

    Hello!

     

    The formulas seem OK to me. Could you please confirm whether you have imported the information to EMP03?

     

    Cheers!

     

     

    Kind regards,

    Bruno Rodriguez

  • NoAmazonAffiliation
    NoAmazonAffiliation
    Yes, the information has been imported to EMP03.
  • NoAmazonAffiliation
    NoAmazonAffiliation

    And this is my SYS08, where I had to choose the List: E3 format for Role in order for the EMP02 formulas to be considered valid:

     

    NoAmazonAffiliation_0-1652690868730.png

     

  • AdamCookson
    AdamCookson

    Hey,

     

    From what I can see you're formula logic is correct, but it seems you may be missing the lookup data required. Within your module SYS08, do you have values populated for Start/End Dates, Department and Role? If not you'll need to import them. If these are populated you should get data appearing.

     

    For example, SYS08 should look like this:

    AdamCookson_0-1652951951279.png

     

    If that module is populated, then I think the only other problem would be that your Employee Drivers module EMP03 is blank.

     

    Hope this helps

    Adam

Categories