Wrong Average

[Anonymous]

((max([Unit Goal]))-(sum(UNITS)))/(52-(count(distinct(WEEK))))

This expression is giving me the wrong average units per week.

currently, 38 fiscal weeks have elapsed, the rep max goal is 2000, her current number of units is 1596.2, weeks remaining is 14.

This expression should give me a result of 28.8 units /week to hit her goal, but its giving me 25.2units/week.

can anyone shed any light on this?

its in a table with rep name for first column, and then each column over is a different metric.

As always, any assistance appreciated.

thanks

[Anonymous]

Did some testing Qlik is doing count(distinct(week) as 36 weeks, but there is 38, I have checked my source file and there are 38 distinct weeks.

any reason why qlik would skip two weeks? this is the problem

[Anonymous]

sorry that was wrong, had filtered data

[Anonymous · Accepted solution]

solved it myself 🙂

needed to add "total" to count distinct week as she only had business in 26 weeks and it was filtering based on her number vs all actual weeks remaining.