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))
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))