RE: Omit record from SQL AVG based on field value

Chris,

This did the trick.  It also pointed out that I had my subtraction
backwards all this time which is why the case statements weren't working
like I thought they should.

Thanks for the help.

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Payne
Sent: Friday, February 02, 2007 2:42 PM
To: Midrange Systems Technical Discussion
Subject: RE: Omit record from SQL AVG based on field value

Select
Cast(
 Sum(
  Case
   when (locftst - locbtst) > 0 then (locftst - locbtst)
   else 0
  end
 )
 /
 sum(
  Case
   when (locftst - locbtst) > 0 then 1
   else 0
  end
 )
As dec(20,6))
from some_table

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.