Hi All

Im a beginner in filemaker and I just want to ask how to get ranking of fields. I have 10 fields which is:

Average1

Average2

Average3

...

Average10

Each of them has an average score. I want to get the top 5 from their score by putting it on another field calculation which is Top1, Top2... Top5.

I got the Top1 by this calculation:

Top1 = Max ( Average1, Average2, Average3 ... Average10 )

But I have a difficulty in getting the Top2 ... Top5

Here is an example:

Average1 = 5.0

Average2 = 3.2

Average3 = 8.5

Average4 = 6.5

Average5 = 4.8

Top1 should be 8.5

Top2 should be 6.5

Top3 should be 5.0

Top4 should be 4.8

Top5 should be 3.2

Thanks

IF you want one field per "TopAverage", then you'll have to do some work to cull from the list.

Review the functions LeftValues and MiddleValues.

Each TopAverageField would have the same calculation as my original example but use these functions to take one row, depending on the fieldName.

So Top1 would be

Top2 would use the MiddleValue function in line 7

Top3 would be:

And so forth. Notice for Top2 and Top3, I'm using the middleValues, which asks me first for the list, then the starting row, and how many rows after that.