1 of 1 people found this helpful
I think the answer you need, is to wrap the Spend column with a ISNULL() command. So it should look like this:
ISNULL([trans$].[Spend], 0) as [Spend]. Depending on the coding language the syntax might be IS_NULL, but ISNULL works for MSSQL & MYSQL. ISNULL will convert nulls to a default value, in this case should be 0.