Question 6 in level 1 model building exam

Options
titanic_neo
titanic_neo Member, ALL USERS, GroupMember, Community Member Posts: 4 Occasional Contributor
in Planning & Modeling

Could anyone who has finished the exam show me the formula for question 6? I failed 2 questions for this part.

I think I just need to refer the relevant numbers from another module and apply selections, and then it could be done. However, my way didn't work.

Here's my formulas. Thanks very much!

4c56da1c45b1f6ce26b2ded2718ee74.png

SharedScreenshot.jpg

 

 

Tagged:

Comments

  • maytheforcebewithlin
    maytheforcebewithlin Member, ALL USERS Posts: 1 New Contributor

    Hi, you will need to use lookup function as the answer requires both region and role.  

  • HXTrainer360
    HXTrainer360 Member, ALL USERS Posts: 1 New Contributor

    I passed the exam without getting the answer to this question my formula: 

    'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]

     

    The result was 21,600 for FY21. This was not the correct answer. Did I do my formula wrong?

    funny enough the I got next question America, Executives, Bonus, FY21 correct using the value in the module.

  • BharatKDeshmukh
    BharatKDeshmukh Member, ALL USERS, Partner Posts: 1 New Contributor

    Check REP03 module .

  • nileshs
    nileshs Member, ALL USERS, Partner Posts: 3 New Contributor

    I used the same formula mentioned but the results is blank.

    I see no data in sys08 region and role. they are formatted as list G1 and E3

Categories