How to rank field data in Filemaker Pro 8.5?
I have a field which is a column of numbers e.g
I have a column next to this which i need to rank the above 4 numbers and where they come in the data set (lowest to highest) without sorting them into order e.g.
2 = 3
0 = 2
-1 = 1
3 = 4
How do i define the dataset in Filemaker Pro 8.5 to do this automatically?