12 Replies Latest reply: Jun 1, 2017 10:31 AM by Jagveer Dhillon RSS

    Rank Function not including both -ve and +ve values

    Jagveer Dhillon

      I am trying to get the bottom 10 service levels for our Items supplied by various vendors. which is basically Supply vs demand for each vendor for YTD. I am using the Rank function as mentioned below

       

      =AGGR(IF(Rank(-(Sum(AVAILABLE)/Sum (DEMAND)),4)<=10,ITEM), ITEM)

       

      The top 10 works fine. but for bottom 10 i get just 1 record where the available is in -ve. therest 9 records do not show up.

      if i create a simple table and i check the records, there are various items which satisfy the criteria and they should show up.