4 Replies Latest reply: Sep 9, 2015 9:09 AM by Bladen Brannon RSS

    Rank Function

    Bladen Brannon

      I have a issue that I have not been able to find a work around for.  I am trying to populate a text box with the rank of a sale person relative to the total sales person population.  To do this I have been using AGGR with Rank in the formula below.  This works fine until I filter by a product where the sales person has not sold anything.  In those cases it is returning "-" in the text box.  Ideally it would treat no sales as $0 sales and return the appropriate rank.

       

      Any insight would be greatly appreciated.

       

      =Aggr(Rank(Sum({_MTDFlag={1},SalesPerson=>}Sales),1,1),SalesPerson)

       

      Selections

      Salesperson List Box

          - Salesperson A

       

      Sum Result

      Sum({_MTDFlag={1},SalesPerson=>}Sales)

           -$0

       

      Expected Result

      46

       

      Current Result

      -