Sum with Null values

[smeco]

I have a report which gives me various sums, some of which will be null if there is nothing to add up

I then tried to create a grand total, by adding up the various sums - the problem is that if one of those sums is null, then I get null for the grand total, too

how do I solve this?

thanks in advance
smeco

 

[bat17]

ust the isNull function. isNull([Myfield]) + isNull[MyOtherField])

HTH

Peter

 

[smeco]

I tried isNull but it seems to give me just 1 and -1 depending on whether it's null or not - what I need is the sum of all non-null values really

 

[bat17]

Sorry! my brain seems to have siezed up
Should have been the NZ([myField],0) function

Peter