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.





      Salesperson List Box

          - Salesperson A


      Sum Result




      Expected Result



      Current Result