2 Replies Latest reply: Jul 19, 2011 2:35 AM by Rob Wunderlich RSS

    Removing top 5 and bottom 5 values

      Hi,

         I need to find the average of overall experience values every month. The trick is that the average is done by reoving the top5 and bottom 5 values. Eg, if we have 100 values we need to average from 6 to 95. Any ideas on how to do it? Either in scripting or chart expression is appreciated.Thanks in Advance.