4 Replies Latest reply: Jun 2, 2016 4:21 PM by Onno van Knotsenburg RSS

    Averaging excluding outliers



      I am trying to average a variable called "Days Past Due for Loans" but only taking into account values that are less than 361 days.


      The variable is called: [Final Current DPD status]


      I am trying to do this through an If statement:

      IF([Final Current DPD status]<361, Avg([Final Current DPD status]),' ')


      Is this the best way to take out the outliers from the calculation?