Text Field not calculating correctly

[daperez5209]

In Acrobat Pro XI.

I created an order form that is not calculating correctly. If you refer to the image below (sorry for poor penmanship), the items are marked as followed:

F1 - Visible Field, Fillable by guest. Guest selects quantity requested

F2 - Hidden Field , Simplified Field notation (Price in this case)

F3 - Hidden Field(visible now for the post), Value is PRODUCT of F1, F2

CT1 - Hidden Field (visible now for this post), Value is SUM of all selected items in category (there are multiple categories in the form)

ST1 - Hidden Field (visible now for this post), Value is SUM/SUBTOTAL of all categories

Based on the info above, ST1 should equal the same as CT1, but for some reason the first line (braised short rib) does not calculate in ST1. On screenshot 2, the first item is not selected, but ST1 value has increased by the amount of F2, all while the value of CT1 is correct.

In total, there are over 300+ calculations in which 99% of them work correctly and all with similar formulas. I have deleted and recreated ST1, but doing this has caused other categories to have errors in calculations. I have created other forms with similar issues and cannot find a resolve to my issues.

Any help will be MUCH appreciated.

[George_Johnson · Accepted solution]

This is often due to an incorrect field calculation order. How you set it depends on which version of Acrobat you're using, but for Acrobat 11 you'd select:

Tools > Forms > Edit

and then: Tasks > Other Tasks > Set Field Calculation Order

[daperez5209]

This worked! Thank you so much.