asked on

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

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

Brock

ASKER

Sorry...I am using Crystal 8.5.

Thanks, Lucy

Spykair

Hi Lucy,

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

Spykair

Spykair

*function

Brock

ASKER

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

Brock

ASKER

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

ASKER CERTIFIED SOLUTION

bdreed35

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Brock

ASKER

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