Eliminating the high and low values from an average calculation in Crystal
Posted on 2006-07-21
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?