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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
