top 10 list

[mlindal]

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).

[comment]

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.

[mlindal]

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

[comment]

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, 2010 by Guest