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?
Thanks
Cj