Blank

  • Thread starter Thread starter ash
  • Start date Start date
A

ash

Hi,

Basically I am creating a table where the fourth column is
the sum of the first three.. see example below

1 3 4 8
5 2
3 3 1 7
2 3

The problem I am getting is that (See row 2 and 4 above)
when there is a null (because that value is 0) in the row,
the sum isnt showing up. In my simplified example, there
should be a 7 and a 5 in rows 2 and 4 respectively.

Please please help.
 
I thought I would clarify my post a bit. The table appears
in a report. The data is coming from a cross tab query.
 
Can you just create a new Row Heading in the crosstab that contains the sum?
Use the same expression as your column heading only change it to a Row
Heading.
 
Back
Top