calculating sum in form

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I'm trying to get a sum of values on my form.
=[ProductCostPrice]+[EbFees]+[PayFees]+[Shipping]

If any one of the fields is empty, the formula returns nothing.
If I enter any value in the empty fields, it works.
I set the default value to zero and it still doesn't work.
How can I get the formula to work if any or all fields are populated?
thanks
 
shank said:
I'm trying to get a sum of values on my form.
=[ProductCostPrice]+[EbFees]+[PayFees]+[Shipping]

If any one of the fields is empty, the formula returns nothing.
If I enter any value in the empty fields, it works.
I set the default value to zero and it still doesn't work.
How can I get the formula to work if any or all fields are populated?
thanks
Click to expand...

=Nz([ProductCostPrice],0)+Nz([EbFees],0)+Nz([PayFees],0)+Nz([Shipping],0)
 
Back
Top