1 Reply Latest reply on Jan 15, 2010 5:47 AM by comment_1

    How to rank field data in Filemaker Pro 8.5?

    CL

      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.