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:








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