90th Percentile

[KJ0281]

Hello,

I have a table with two columns: ProjectID and TAT. TAT is the Total Amount of Time a project is open. I would like to find the 90th percentile of TAT and place that number into a report. Any ideas on how to calculate the 90th percentile?

I am new to VB so any code would be very helpful.

Thanks,
KJ

 

[UncleJack]

KJ
You need to specify what you mean by the 90th percentile. What is the base for the 90th percentile - is it within a particular task or is it a function of the aggregate of all the open projects, or is it something else? It would be better if you could define a specific mathematical relationship.

If you do then I'm sure one of the excellent programmers who frequent this site will respond with a neat solution for you.

Uncle Jack

 

[KJ0281]

I need to know the Total Amount of Time that 90% of projects were completed in. Say I have a list of 10 projects sorted by TATs. The 90th percentile is the time associated with the 9th project on the list since 90% of the projects were completed in that time.

 

[Craig0201]

KJ0281,

You need to look for the TOP keyword in SQL. This should give you everything you need. If you need any help figuring it out, give me a shout.

Craig