<div>
The time summary counts have some items excluded based on criteria, the overall do not. i have a disclaimer in the report explaining this. thanks for the help.
</div>


The time summary counts have some items excluded based on criteria, the overall do not. i have a disclaimer in the report explaining this. thanks for the help.

<div>
<div class="content wysiwyg-content">
I am trying to determine the 90 percentile for time summary, it appears using the selection for Percentile that the summary seems to be higher than expected, I want to be sure that i am using this correctly. I first calculated the time difference shown below, then summarized it using the 90th percentile in the summary selection. Any help would be appreciated. Thanks<br />
<br />
({@Enroute Time}-{@Dispatch Time})*1440<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2010/11_w48/374124/Time-Summary.jpg" target="_blank" title="Screen Shot of 90 Percentile Summary (16 KB)"><img alt="Screen Shot of 90 Percentile Summary" class="file-block lazyload" style="max-width: 794px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w48/374124/Time-Summary.jpg" /></a> <br />
<a href="https://filedb.experts-exchange.com/incoming/2010/11_w48/374126/Summary-Screenshot.jpg" target="_blank" title="Screenshot of summary selection (7 KB)"><img alt="Screenshot of summary selection" class="file-block lazyload" style="max-width: 330px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w48/374126/Summary-Screenshot.jpg" /></a>
</div>
</div>


Time-Summary.jpg

Summary-Screenshot.jpg

I am trying to determine the 90 percentile for time summary, it appears using the selection for Percentile that the summary seems to be higher than expected, I want to be sure that i am using this correctly. I first calculated the time difference shown below, then summarized it using the 90th percentile in the summary selection. Any help would be appreciated. Thanks

({@Enroute Time}-{@Dispatch Time})*1440


 


Time Summary using percentile P=90

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.