Prev: Expression using RIGHT and LEN functions
Next: Unmatched query
From: chibby racer <chibby on 24 Feb 2005 11:19
What is the easiest way to calculate percentile in access?
From: Rick B on 24 Feb 2005 11:24
More details please.

If you have two fields in a record (total sale price, discount amount) then
you would use simple math to calculate. If you want to know what percentage
a value is of the totals for that value in a table, then you have to do it
in queries or reports.

Rick B



"chibby racer" <chibby racer(a)discussions.microsoft.com> wrote in message
news:4C97ADF9-7FEC-4F61-8DB6-47CCF8E43187(a)microsoft.com...
> What is the easiest way to calculate percentile in access?


From: chibby racer on 25 Feb 2005 08:03
To clarify, I would like to rank a group of agents based on a certain metric,
and then calculate the percentile to compare their relative performance. I
can already generate a rank for each of the agents, but just having trouble
getting the max rank, so I can have rank 12 out of 123.

Any ideas?

"Rick B" wrote:

> More details please.
>
> If you have two fields in a record (total sale price, discount amount) then
> you would use simple math to calculate. If you want to know what percentage
> a value is of the totals for that value in a table, then you have to do it
> in queries or reports.
>
> Rick B
>
>
>
> "chibby racer" <chibby racer(a)discussions.microsoft.com> wrote in message
> news:4C97ADF9-7FEC-4F61-8DB6-47CCF8E43187(a)microsoft.com...
> > What is the easiest way to calculate percentile in access?
>
>
>
 | 
Pages: 1
Prev: Expression using RIGHT and LEN functions
Next: Unmatched query