Can not get sum of summary colums 1

[north2060]

I am trying to get the total of summary fields. I have five summary fields and created a formula field which add up all summary fields. I get correct total if all summary fields have the value otherwise it is blank. Can I have a suggestion how I can get the total of the defined summary fields?

 

[Madawc]

For Crystal 8.5, try testing 'isnull' before trying to add a summary field. A standard format is
if isnull ({your.field}) then 0 else {your.field}

Crystal always stops when it finds a null that hasn't been tested for.

Madawc Williams
East Anglia, Great Britain

 

[north2060]

Thank you! for your help. I haven't tried yet but I think it will work.

 

[north2060]

Thank you again, it works. You are great.