Help With Calculations

[gnarpeggio]

I'm trying to figure out a way to add 3 fields together but will still calculate the total if 1 or 2 of the fields are left blank. I'm hoping to avoid using zero values for the blank fields if possible.

Is there an expression or code that will add the subtotal of these 3 fields and ignore 1-2 of the fields if needed?

Thanks in advance!

 

[John Big Booty]

Have a look at the NZ() function. You could use something along the lines of;

=NZ(Field1,0) + NZ(Field2,0) + NZ(Field3,0)

 

[gnarpeggio]

This is exactly what I was looking for. Thank you good sir!!!