Summary Calculation(based on queries) when the queries have 0's

[Arsenal]

Hi All,

I have another problem ???

I have a report 6 lists setup within tables. Each of those lists have their own queries, of course.

Now, I need a grand total summary row which would say something like query1.totalamount+query2.amount+query.totalamount and so on

Problem is whenever there is a 0 in the amount fields in the other 6 queries, then the grand total row ends up missing (i.e. a big blank) in the footer

I've tried is null, is missing , = 0 comparisons but no go

Any suggestions?
Thanks

[Suraj]

do a union or join and sum them up for the summary row.

[Arsenal]

I did a 2 union's  (query 1+query2) and (query 3+query 4)

Then I used the data item from union 1+ data item from union 2 in the list outer summary cell for the grabnd total

but, the 0 still won't show up..only a blank does.

i don't see what the problem with adding 0+0+0 is. Can't understand why Cognos won't just display a 0