L1 Activity 6 - Wrong Calculations... Help Please!

I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020.

 

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

 

REP04.pngREP04.5.png

 

It draws from SYS08:

 

SYS08.png

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

 

EMP02:

 

EMP02.pngEMP02.5.png

 

EMP03:

 

EMP03.pngEMP03.5.png

Can anyone help an amateur Anaplanner on where I am going wrong?

Comments

  • Hi @tspoon ,

     

    Just by having a glance at your screenshot of EMP03, I think you could consider changing the Summary Method (the column next to the formula). The summary method for Bonus % is currently on SUM, do you really want a summation of the Bonus percentages? I suggest you try another option, I won't say which one but have a think which one will be most useful to you.

     

    Hope this helps,

     

    Ege