12 Replies Latest reply: Apr 11, 2014 8:45 AM by Ola Amphan RSS

    Max value below fractile

    Ola Amphan

      Hi,

       

      I have a set of salaries and would like to find the lowest/highest value below or over a fractile. The fractile function gives me the cut-off point but how do i get the highest or lowest value below or over the cut-off point?

       

      Let's say I have the set below:

       

      Payroll:

      LOAD * INLINE [

          Salary

          3000

          4000

          5000

          9000

          11000

          13000

          17000

          19000

          22000

          30000

          45000

          67000

      ];

       

      fractile(total Salary,0.25) gives me the cut-off point 8000 but how do I get the value 5000? And fractile(total Salary,0.75) gives me the cut-off point 24000 but how do I get the value 30000?

       

      Many thanks in advance,

       

      Ola