Fixing the calculation for the Total field

Now that you have reorganized the contents of your form, the calculation for the total needs to reference the new Table subform.

1. Select the Total field.

2. Drag the Script Editor palette bar until the palette is the required size to show multiple lines.

3. In the Script Source field, revise the script to show the following calculation:

   sum(Table.Table1.Row1[*].amount[*])

4. Deselect the Total field to add the script to your form design.

Click to continue: Setting the fields to read-only

Twitter™ and Facebook posts are not covered under the terms of Creative Commons.