3 Replies Latest reply: Jul 19, 2018 8:53 PM by Kenneth Holden RSS

    Wrong Average

    Kenneth Holden

      ((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