Skip to Content
Former Member
Jul 08, 2009 at 09:48 AM

Exclude count where the amount is zero


Good morning

I need assistance in the following please?

I have a query where I display the Top 20 expenses (amounts) and the number of records (occurrences) for those expenses.

The number of records is a count of all the credit note numbers created for the expenses (lowest level).

I am also excluding the 0.00 amounts from the query with a condition.

I need to exclude the count where the amount = 0.00 as well, but I cannot get that to work. It still counts all the occurrences no matter if the amount is o.oo or not.

Please assist?