Tie Breaker in Rank Function

[trmcbrad]

I'm currently using this formula to rank counts.

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

However, I'm getting the result below.

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

Thanks!

[sunny_talwar · Accepted solution]

Try this may be:

=Num(Rank(Count(FacilityAccountID),4,1))

[trmcbrad]

Thank you so much for your help!!!!!!!