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