RE: Omit record from SQL AVG based on field value

There is nothing syntactically or logically wrong with your statement.
Make sure locftst is greater than locbtst in some of the rows at least.

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: RE: Omit record from SQL AVG based on field value


I've been trying the case but it returns null for the average and I know
that's not correct.  I tried it in the detail portion also and it is
substituting for every value not just the ones in error.

Here's the last try at using case.
Cast(Avg(case when (locftst - locbtst) > 0
                then (locftst - locbtst)
                  else NULL end) as dec(20,6))

Rick