Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Averages - removing extremes Post Reply Post New Topic
Author Message
Fozzy
Newbie
Newbie


Joined: 03 Jul 2009
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote Fozzy Replybullet Topic: Averages - removing extremes
    Posted: 03 Jul 2009 at 3:47am
Hi
 
I have been asked to provide a report showing average completion times for work for the purposes of targets.  It is accepted that extreme cases should be excluded as these will skew the averages dramatically and unfairly.  I would like the report to exclude the top and bottom 'x' number of cases before the average summary is calculated for each handler.
 
Can anyone provide a suggestion for doing this? Thanks.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 06 Jul 2009 at 6:59am

What I would do, is build a string, an array would do was well(I just don't use them enough in Crystal, but here is a place I would try them out) and place the details in sorted order.  then in your footer, you could skip the entries you don't want and sum up the rest in a formula and report back the number.

Interesting that they don't also want a median, as that counters the extreme values...oh well, give them what they want.
 
regardless, what you need to do is build a record of all the values in order(one way or another) and then remove the ends....based on what(the size of the set?)
 
Good luck,
HTH
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.