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:
It draws from SYS08:
I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.
EMP02:
EMP03:
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
0