AnsweredAssumed Answered

How to rank field data in Filemaker Pro 8.5?

Question asked by CL on Jan 15, 2010
Latest reply on Jan 15, 2010 by comment_1

Title

How to rank field data in Filemaker Pro 8.5?

Post

Hi,

 

I have a field which is a column of numbers e.g

 

 2

 0

-1

 3

 

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?

 

Thanks.

Outcomes