Solved

Eliminating the high and low values from an average calculation in Crystal

Posted on 2006-07-21
7
401 Views
Last Modified: 2008-02-01
Hi:

How do I kick out the high and low values from an average in grouped data in Crystal.  The client does not want a weighted average.

I think that I may have to manipulate the code in the stored procedure before doing the calculation in Crystal reports..

As I am at home right now...I don't have the report writer infront of me but is there a conditional running total that would eliminate the highs and low values within a group?

Thanks, Lucy
0
Comment
Question by:Lucia
  • 4
  • 2
7 Comments
 

Author Comment

by:Lucia
ID: 17153196
Sorry...I am using Crystal 8.5.

Thanks, Lucy
0
 
LVL 10

Expert Comment

by:Spykair
ID: 17153253
Hi Lucy,

Yes, there is a minimum and maximum functino within the running total that you'll be able to use.

Spykair
0
 
LVL 10

Expert Comment

by:Spykair
ID: 17153256
*function
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:Lucia
ID: 17153274
Thanks, as soon as I get in I will try it .  I will let you know  how it works. Lucy:-)
0
 

Author Comment

by:Lucia
ID: 17154447
Hi :

I am still having problems:

So I have a formula called Total Case Times
                                        10
                                        15  
                                        23
                                     --------
                                        48

I want to eliminate the 10, and 23 from calculating in the average...(thats what client wants).

Do I use the nthlargest and nthsmallest ...?

Thanks, Lucy
0
 
LVL 28

Accepted Solution

by:
bdreed35 earned 500 total points
ID: 17155020
I think you are going to have to look at using manual running totals.
Before I post a solution, is the average going to be for the whole report, or for a grouping?  IF it is a grouping, what is the field you are grouping on?

0
 

Author Comment

by:Lucia
ID: 17155807
Hi bdreed35:

field:{@Total Case Time}
what I am grouping on {NHS_Setup_Proc_Teardowns_85193.proc_mnc}

Can the running total be done on a calculated field.

Thanks, Lucy
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question