ErcanOPAK.com

SELECT
    AVG (CASE WHEN Value <> 0 THEN Value ELSE NULL END)
    ....

AVG function will not take into account NULL values.

So you can also use this

AVG (NULLIF(Value, 0))