Drew Wutka
DWUTKA at marlow.com
Thu Oct 16 13:04:31 CDT 2003
Write a query for the top ten based solely on category 1. What you need is the total score for #10. Then write a query for everyone's score. If they aren't in the first querries top 10, subtract the difference between #10 and #11. Drew -----Original Message----- From: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Thursday, October 16, 2003 12:18 PM To: AccessD Subject: [AccessD] Who likes math! I have a report that has 11 categories. Each are scored from 1 - 100. Through refining the report some categories weigh less now for example category # 11 weights only 50% of the value thus a perfect score there is only worth 50points vs a perfect score on Category ID 1. I was taking these individual category points and tallying them up and sort them in descending order thus those w/ the most points wins (those at the top). Now My boss wants to now take those guys who do not meet the goal at category 1 to not be allowed to be in the TOP 10. I tried watering down their points first by only giving them 75% of their total points down to 10% but the boss thought that probably wasn't a good idea. My point is how do you fairly guage this, and how would you do it to rank 11 categories over 30 sub-companies Category % of 100points 1 100 2 3 90 4 80 5 80 6 90 7 100 8 90 9 90 10 60 11 50 when I sum up all the points I get something like in the 900 or the like, when one sub-company and another are tied, they both take up the same ranking number such as 1, 2, 2, 4. the next spot automatically is shifted to the next ranking value not 3rd place, but 4th. How could I take a company that is ranked in 3rd place overall score but knock them down to be 11th place only because they didn't meet the primary criteria? What this assures is that anybody that ever fails to meet the primary category can't qualify in the top 10. thanks. -- -Francisco _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com