AnsweredAssumed Answered

Create Ranking by Calculation

Question asked by ienalpe28 on Feb 19, 2017
Latest reply on Feb 28, 2017 by ienalpe28

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

Outcomes