Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes.

I’ve found that applying Nz () correctly can be a bit of a puzzle for some folks. The key is to wrap every field or value in an Nz () function, not the entire expression.