Level 1 Model Building Activity 5/6. Super Stuck - Need Help

tspoon
tspoon
in Modeling

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:

Screen Shot 2022-03-18 at 10.27.06 AM.png

 

Screen Shot 2022-03-18 at 10.27.20 AM.png

 

It draws from SYS08:

 

tspoon_2-1647616836522.png

 

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

 

EMP02:

 

tspoon_3-1647616836579.png

 

tspoon_4-1647616836497.png

EMP03:

 

tspoon_5-1647616836485.png

tspoon_6-1647616836697.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

Tagged:

Answers

  • LaurenF
    LaurenF

    The first thing I would check is your dimensionality for REP04 agains the requirements - do you need region, role, and department? Then you can address the SUM formula. 

     

    I went thru Level 1 a while ago and some updates were made to the training since then. I don't have the "right" answer in front of me. I hope you get unstuck soon!

Categories