Sum of variable is displaying blank instead of 0

[src2]

I have a CR 8.5 report that calculates opened and closed call tickets based on ticket type by tech. The report is working correctly except for a small item. For a particular ticket type if there are only a few records and none of the records are closed, the total closed is showing up as blank instead of 0. Anyone have any ideas how I can correct this problem?

Thanks

 

[Naith]

You have null values in the field you are attempting to sum, most likely. Convert null values to zero at the report level, or implement a null handler in your formula.

Naith

 

[Madawc]

As Naith says, you get blanks when a total is null, this can apply even to running totals.
Write a formula field to check the total
if isnull ({your.total})
then 0
else {your.total}

Display it instead.

Madawc Williams
East Anglia, Great Britain