August 22, 201015 yr This is probably simple, but I'm a bit rusty so if you can help, I would love it! I'm trying to find the top 10 scores for a field. Then I need to average these top 10 scores and put it into another calculation. There are a few calculations I may develop based on similar things. (ie top 5 scores if there are less than 10 records).
August 22, 201015 yr To find (as in found set) the 10 top-scoring records, you could show all records, sort them by score (descending) and omit records from record #11 and on. Note that this is not exactly the same thing as the top 10 scores in case of a tie. --- P.S. Are you really using version 6? If not, please update your profile.
August 22, 201015 yr Author I am guessing there is no straight calculation to accomplish this, but it will require a script? Sort field Omit records take the scores and put them in a global field Average that field... Put that result in another global field Anything simpler? Thanks, Mark
August 22, 201015 yr It could be done without a script, but I doubt it will be simpler. It also depends on whether you need the top 10 of found set only or of all records in the table. Sort field Omit records take the scores and put them in a global field Average that field... Put that result in another global field I believe it should be: Sort Records Go to Record #11 Omit Mutiple Set Field [ gAverage ; sAverage ] where sAverage is a summary field. Edited August 22, 201015 yr by Guest
Create an account or sign in to comment