Ranking Scores

[ecugrad]

I'm using Cystal 8.5..

I have productivity scores for each of our 109 employess, the scores are from 77.03 - 99.59. My goal is to create a formula that would give a numerical ranking from 1 - 109 for each employee based on their score.

I'm by far not close to an expert in Crystal, but will try any suggestions tha tcome my way.

Thanks

 

[chelseatech]

If they are all detail records, you could use Recordnumber in a formula.

If they are grouped, use this formula
WhilePrintingRecords;
Global Numbervar RankNumber := RankNumber + 1

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[HowardHammerman]

If there is no need to group the data, sort the data on the score. Then create a running total that accumulates once per record and resets never.

If you have multiple records per employee, group on the scope and in your running total accmulate once per group.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269