Find AVG : Exclude values which are 0 while finding AVG

It would be interesting to see the full query, since the [1], [2] and [3] looks like the could be the result of a pivot operation. It may be simpler to do what you ask for before the pivoting.

Don't forget to tell which version of SQL Server you are using.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se