
1. Re: Having trouble with result not changing if another number is added into the equation....
Bernd Alheit Jan 19, 2018 9:19 AM (in response to stepheng54012748)1 person found this helpfulCheck the calculation order.

2. Re: Having trouble with result not changing if another number is added into the equation....
stepheng54012748 Jan 19, 2018 4:15 PM (in response to Bernd Alheit)That doesn't work. Not sure how to remedy this. The issue is the script I wrote for Cell F accepts whatever number I enter and it will change what actually shows in the cell based on the formula. If I enter information into Cell H and/or Cell I this needs to change the calculation in Cell F. In the example above if I enter 250 it changes to 150 and this is correct. If I enter amounts in Cell H and/or Cell I then the number in Cell F should go down based on the 250 that was entered. I'd to add to my validation script something that would make this happen. If I go to Cell F and retype in the 250 then it calculates the new number based on what I enter in Cell H and Cell I.

3. Re: Having trouble with result not changing if another number is added into the equation....
gkaiseril Jan 19, 2018 4:33 PM (in response to stepheng54012748)1 person found this helpfulAre you sure your field calculation order is correct. PDF forms are not Excel and form fields are not calculated left to right and then up to down. Calculation Order is not the same as tab order. It is a completely different setting from everything else. Also, one could place all the calculations in one field and perform the calculations and set the field values in the desired order You will find the "Set Field Calculation Order" under the "More" option for the "Prepare Forms" tool.
Are you getting any errors in the Acrobat JavaScript consloe?
Open it using the "<Ctrl> + J" key combination.
A link to your form or a sample form with the same issue might be helpful.

4. Re: Having trouble with result not changing if another number is added into the equation....
Thom Parker Jan 19, 2018 4:33 PM (in response to stepheng54012748)You've described a classic calculation order issue, you need to check the calculation order dialog as gkiseril has described above.

5. Re: Having trouble with result not changing if another number is added into the equation....
stepheng54012748 Jan 19, 2018 4:36 PM (in response to gkaiseril)Placing all of the calculations in one field was the answer with this. I was trying to get too fancy with this. THANK YOU!

6. Re: Having trouble with result not changing if another number is added into the equation....
gkaiseril Jan 19, 2018 4:57 PM (in response to stepheng54012748)1 person found this helpfulBy having one calculation the issue of field calculation order comes down to 1 field.