Skip to Content
0
Former Member
Nov 13, 2008 at 09:09 PM

find 90th percentile row

73 Views

I have a report that returns response times. I have them in order from fastest to slowest. I have a count summary so each row has it's own number. I have a formula that take the grand total and multiplies it by .9 and that tells me the row that is the 90th percentile. What I want is just to see the 90th percentile row. An example would be if I had only 100 records, I would only want to see the detail in row 90 if I had 360 rows, I would only want to see the detail in row 324, etc...