Print Page | Close Window

percentile calculation Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21323 Printed Date: 05 May 2024 at 1:23am Topic: percentile calculation Posted By: scott.morrison Subject: percentile calculation Date Posted: 29 Jan 2015 at 7:58am I am returning a count and a percentile for total calls by hour. I am counting the call number (a unique id) for each hour then dividing by date to find average calls per hour. How can i find 90th percentile by hour? the field available are    table.date, table.callnumber, table.calltime ------------- V/R Scott

Print Page | Close Window