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!
Comments
-
Hi, you will need to use lookup function as the answer requires both region and role.
0 -
Also another hint. You're very, very close.
Use the SUM function on Region and Role from your SYS08 module.
Breakdown:
- YOu need Medical costs from EMP02 which uses Employee as a dimension but your TARGET module, REP04 is dimensioned using Region and Role.
- So you need to convert your employee dimension to region and role. Your SYS08 does this!
- Remember, you always use SUM on a list formatted line item.
- So your formula will look something like this. EMP02.Medical Costs[SUM: SYS08.Region, SUM: SYS08.Role]
You got this!
4 -
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.
0 -
Check REP03 module .
0 -
How would I go about adding Department and Role to SYS08? I don't believe that was a part of the exercises which I followed step by step. This is what I have for my SYS08:
I have Department and Country...
0 -
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
0 -
Moved post to Academy & Training forum.
FYI @titanic_neo @nileshs @tspoon @BharatKDeshmukh @HXTrainer360
0
