NUM! error with Nz function

[Nick Mirro]

Data source for text control:

=((Nz([CPT1PaymentTotal],0)+Nz([CPT2PaymentTotal],0)+Nz([CPT3PaymentTotal],0
)+Nz([CPT4PaymentTotal],0)+Nz([CPT5PaymentTotal],0)+Nz([CPT6PaymentTotal],0)
)/(Nz([TotalBilled],0)))

Returns "NUM!" If values in source fields are null.

Shouldn't all these Nz's prevent this?

 

[Kelvin Lu]

You have a divide by 0 error. The last division will always cause an error.
Change the last NZ to use 1 instead of 0 so that you don't get a divide by
0.

Kelvin

Data source for text control:

=((Nz([CPT1PaymentTotal],0)+Nz([CPT2PaymentTotal],0)+Nz([CPT3PaymentTotal],0

)+Nz([CPT4PaymentTotal],0)+Nz([CPT5PaymentTotal],0)+Nz([CPT6PaymentTotal],

0)
)/(Nz([TotalBilled],0)))

Returns "NUM!" If values in source fields are null.

Shouldn't all these Nz's prevent this?