2 Replies Latest reply: Aug 9, 2016 12:07 PM by Brad Guillot RSS

    Tie Breaker in Rank Function

    Brad Guillot

      I'm currently using this formula to rank counts.

       

      =rank(count(FacilityAccountID),0,1)

       

      However, I'm getting the result below.Capture.JPG

       

      How do I break the ties in the Rank number column? Is there another field that can be used to break the tie?

       

      Thanks!