I found a way -- not sure if it is the most efficient, but it works. I'm creating a second table with a max(rankcounter) column. I then JOIN both tables and use the max(rankcounter) in a formula.
I found a way -- not sure if it is the most efficient, but it works. I'm creating a second table with a max(rankcounter) column. I then JOIN both tables and use the max(rankcounter) in a formula.