2 Replies Latest reply on Dec 5, 2012 5:44 PM by Ey Tan

    Percentile range does not cover up to 99+%

    Ey Tan

      Hello all,

       

      I'm using this formula to find percentile (as part of a step to derive trim mean)

      (INDEX() -.05)/Total(Count([Number of Records]))

       

      However under "view data", the range of values for percentile does not cover the whole distribution:

      Month    Donut Sales $    Percentile

      Oct    5,710    3.17%

      May    5,504    6.50%

      Jun    5,041    9.83%

      Feb    4,081    13.17%

      Jan    4,071    16.50%

      Jul    3,854    19.83%

      Sep    3,759    23.17%

      Aug    3,631    26.50%

      Mar    3,540    29.83%

      Apr    2,858    33.17%

       

      Sorry for the dumb question, what went wrong with the way I did up the formula for percentile?