base query sum(amt) returns null value if not rows match

have a query that sums a column but if no match returns null instead of value 0. This causes a follow up query to fail which uses that output


you can use COALESCE e.g. SELECT SUM( COALESCE ( “sales”, 0 ) ) “Revenue” FROM “tblSales”

I tried answer 1 above. It simply returns a table with no values I am looking for a row to be return with the number zero in the field. Any suggestions would be appreciated.

Just take the sum out and you see all values 0 inclusive