calculating sum in form

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
 
R

Rick Brandt

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Turning off automatic calculation 0
Copy previous record into form field 0
Weighted % Complete calculation 1
Total Calculation 3
Zeros Showing in Form Field 4
Sum data using sumif 3
How do I clear a form? 0

Top