Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To: Get a better average
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01447163
Message ID:
01447175
Views:
34
Kevin, I agree. That is something we are looking at. This is the first real request for a change in this area we've had, and part of our internal promise is to "review" customers suggestions, and often they get implemented. This may turn into a future "option" that they can select how the system calculates that number.

>Kirk, depending on the size of your user base, you may want to talk to the business person (or persons) that drives the product functionality, to see what business rules they want.
>
>Generally, a calculation of median will minimize the impact of outliers, though some like to use the Mode function as well, which will give you the most common observation point value.
Previous
Reply
Map
View

Click here to load this message in the networking platform