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
do a union or join and sum them up for the summary row.
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