How to filter out row if all columns are equal to 0

[laniebe]

Hello! I have a query with the following data - I am trying to determine how to hide/filter out the rows that have a value of 0 in all 6 data columns.

For example, how would I get part number 1234 to filter out of the query results? Thank you!

Item_Number	BeginBal	TotalAdmiss	TotalCons	TotalPosAdjust	TotalNegAdjust	TotalEndBal
1234	0	0	0	0	0	0
5678	50	50	75	0	0	25

[laniebe]

I created a new function that added all columns together and then set the criteria to >0.