L1 Model Builder Exam - Question 5/6: Stuck!

tspoon
edited February 2023 in Academy Discussions

I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 1.5 weeks now.

 

The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04:

tspoon_0-1647808219972.png

 

 

tspoon_1-1647808220098.png

 

 

It draws from SYS08:

 

tspoon_2-1647808219743.png

I keep getting the wrong number whether I use EMP02 or EMP03 in the formula. 

 

EMP02:

 

tspoon_3-1647808219743.png

 

tspoon_4-1647808219743.png

EMP03:

 

tspoon_5-1647808219743.png

 

tspoon_6-1647808219936.png

 

Can anyone help an amateur Anaplanner on where I am going wrong? I have a feeling there's something wrong with EMP02. Maybe that I'm not using region in the formula??? For example, here's the formula for phone costs in EMP02:IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Answers

  • It's difficult to see the logic in your screenshots and unfortunately I'm unable to expand them to get a better view. I can't say for sure what the problem may be without seeing this other information but maybe trying a different function instead of LOOKUP (e.g., SUM) may help. If you can provide clearer screenshots then maybe I could help more