Form fields not adding up, random values appearing

[juanchofrancisco]

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!

[try67]

The problem is with the field calculation order. You can set it via Tasks - Other Tasks, in Form Edit mode.

[gkaiseril]

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.