Suppressed fields not always in sum 1

[tmkraynak]

In a letter type report, I am selectively suppressing field labels and data values so that the report is not cluttered with blank space. I am using multiple detail sections within the detail band with conditional suppression of the sections (along with the suppressing of blank sections).
I want to sum the individual field values and display that in another detail band at the bottom of the other bands.
(i.e. fielda + fieldb +fieldc, of which some were suppressed because there was no value)

The problem is that the formula field does not display the sum! The display of the correct values and supression of the blank sections looks fine. It seems that if any of the suppressed detail lines is zero, the results are zero. I am not using a manual running total (although I have tried this, no dice).

CR v 8.5

Any suggestions?

 

[vidru]

Sounds like some of your 'zero' values might be NULL. You could alter your formula to treat null values as zero like this:

(IF ISNULL({Table.Field1}) THEN
0
ELSE
{Table.Field1})
+
(IF ISNULL({Table.Field2}) THEN
0
ELSE
{Table.Field2})
+
(IF ISNULL({Table.Field3}) THEN
0
ELSE
{Table.Field3})

-dave