E
eanderson
I am new to Access and do not know how to do a ton yet.
We have a report listing the Percentages for a large group of companies. We
are looking to include the percentile ranks within our report.
I am trying to do a count of each company, subtracting their rank from the
total, and then dividing this subtraction by the total minus 1. This is a
convoluted way of coming up with the percentile rank since I do not know how.
I figured out how to do counts but that is not helping since there are
multiple companies with the same percentage. Each of these is counted
separately. The first company is marked 1, second 2, etc. Thus, two
companies, even with the same percentage, are coming up with separate
percentile ranks.
From my madness, I think that I am trying to do a running count that takes
duplicates into consideration.
Percentage --> Rank
100 --> 1
99 --> 2
99 --> 2
98 --> 4
etc.
I hope this makes sense. Can anyone help out or is this too much?
Thanks
We have a report listing the Percentages for a large group of companies. We
are looking to include the percentile ranks within our report.
I am trying to do a count of each company, subtracting their rank from the
total, and then dividing this subtraction by the total minus 1. This is a
convoluted way of coming up with the percentile rank since I do not know how.
I figured out how to do counts but that is not helping since there are
multiple companies with the same percentage. Each of these is counted
separately. The first company is marked 1, second 2, etc. Thus, two
companies, even with the same percentage, are coming up with separate
percentile ranks.
From my madness, I think that I am trying to do a running count that takes
duplicates into consideration.
Percentage --> Rank
100 --> 1
99 --> 2
99 --> 2
98 --> 4
etc.
I hope this makes sense. Can anyone help out or is this too much?
Thanks