Form fields not adding up, random values appearing

Question

Hi There,I've done a couple of these simple order forms where it adds, QTY and Price. This one has 41 rows, not sure if it matters, but it's not working correctly. I've kept it very simple and using basic excel worksheet logic (sum, multiply)Any ideas why the form is acting up?Here is the link:bww_orderform_rev2.pdf - Google Drive Any help would be greatly appreciated.thanks!

gkaiseril · Answer

The number of rows should have no effect on the calculation of price time quantity. Getting the proper values is important.

Have you kept track of the vales entered and the results to see if there is some reason for what appears to be random events?

What happens when you enter 1 for any BWW HOH T Shirts?

Now go to the end and enter the quantity of 1 for the trainer patch. My grand total does not update.

Now enter a zero quantity for any item. My grand total now show the correct result for 1 t shirt and 1 patch.

This indicates an error in the field calculation order.

PDF forms do not calculate in the fixed order that Excel uses. One can specify the exact order for the calculation.

One could also set the Grand Total script to calculate all the rows in the correct order.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded