calculated field displays value only if all the values are complered

[polis]

Hello guys sorry if my question seems silly but i cant find thee way out of it.

Basically i have a field that calculates the sum of other subtotals like this:



=[SubTotal1]+[SubTotal2]+[SubTotal3]

But the value appears only if every subtotal has a value, i want it to still show the value if for example subtotal 2 has no value in it.

I try to set the default property of the subtotals to 0, but nothing happens.

p.s there are some cases where the value appears and dissapears.

thanks in advance

[TheShabz]

look up the nz() function
=nz(subtotal1, 0) + nz(subtotal2, 0) + nz(subtotal3, 0)

[polis]

thanks a lot that is exactly what i was looking for...