Register

Question 6 in level 1 model building exam

titanic_neo
Occasional Contributor

Question 6 in level 1 model building exam

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

2 REPLIES 2
maytheforcebewithlin
New Contributor

Re: Question 6 in level 1 model building exam

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

JaredDolich
Moderator

Re: Question 6 in level 1 model building exam

 @titanic_neo 

Also another hint. You're very, very close.

Use the SUM function on Region and Role from your SYS08 module. 

Breakdown:

  1. YOu need Medical costs from EMP02 which uses Employee as a dimension but your TARGET module, REP04 is dimensioned using Region and Role.
  2. So you need to convert your employee dimension to region and role. Your SYS08 does this! 
  3. Remember, you always use SUM on a list formatted line item.
  4. So your formula will look something like this.  EMP02.Medical Costs[SUM: SYS08.Region, SUM: SYS08.Role]

You got this!


Jared Dolich