1 Reply Latest reply: Oct 24, 2013 12:50 PM by Gysbert Wassenaar RSS

    Sorting within a Rank function

    Jared Papador

      I am trying to obtain the top 25% of members in a given org.  My issue is that around the cut-offs there are ties.  With the Rank(Field, 4) I am able to get the right number of members but the wrong members that make up those numbers.  In a table box I can sort by the Rank first and then by the members ID number.  The issue is I am trying to use this expression in a text object so I am not able to use the sort tab.

       

      Is there a way to Sort by Rank and then ID number within a text object.  I have already tried an Order By IDNumber ASC in the script and it didn't seem to make any difference.