I am running a query on average sales prices over the last 30 days. I am running into an issue where my raw data has line items with a "$0" price that is artificially lowering my averages. Below is a screen show of the query and the column in yellow
http://imgur.com/AdyiHer
What can I do to not have it calculate line items with a "$0" unit price when using an Avg Total?