Division

How can it work if there are no values to use for the calculation?

Be careful, and empty field can be treated as a zero value.

And the result for division by zero is?

Do you receive any error messages?

I get "The value entered does not match the format of the field [Field Name]".

If you change the format of the field, you will see that the field gets a value of "NaN", or a message that the result is "Not a Number".

If you enter any positive number into 'BudgetRow33_2' and leave 'BudgetRow39_2' or enter zero, I get 'Infinity' for the answer. And using a negative number in 'BudgetRow33_2' I get '-Infinity'.

Maybe you need to make sure you are not trying to divide by zero or a null value. And since the Simplified Field Notation does not support logical test, you will have to write a custom calculation script.

I get the message"the value entered does not match the format of the field". I was afraid the problem was null value.When I emptied the fields. Could you please help me with the custom calculation script? I have read about it buy I cannot figure it out.
Thanks

There is a problem when trying to divide by a null value or trying to divide by zero.

You need to enter the code into the "Custom calculation script" box by clicking the "Edit" button next to the box and entering the following code into the pop-up editor window:

Thank you soooo much. I will try that!

It worked!
Thanks gkaiseril!

I am using this script in my form, but i'm still getting the error message that reads "The value entered does not match the format of the field [field name] when i click on a totally different field on the form. For example; i have a form that has some check boxes to select which location you would like to buy. Then in a totally different place on the form it has calculation fields that calculate the cost of your purchase. When I click on one of the check boxes, the error comes up for the field that is the total balance field of the calculations field. I can't figure it out. please help!

Have you changed the field format to 'None' and observe what then appears in the field.

Are you sure all of the fields used in the calculation are numeric values and not texts fields that look like numbers?

Are any of the fields really large or small, this will force the value to be restated in scientific notation or display the result as "Infinity' or '-Infinity" any of these numeric values are treated as text fields in a form field.

Having a sample of the form could be helpful.

how do i get you a sample of the form?