A set sum validation is when FORMS checks fields on different forms within a set to make sure their sum equals the value of another field. If it does not, Verify shows you the individual fields involved so that you can verify them. Examples of this are forms with subtotals and a grand total on different pages.
To set up a set sum validation, follow these instructions:
In the Manager’s Set definition dialog, click Validations. The Set validation dialog appears.
In Total sum field, type the name of the field containing the total you want FORMS to check. Make sure that the field name you type here occurs only once in the entire set.
Sum up fields are fields to be added up and compared with the total sum field. (Note that each sum up field must occur only once within the set. That is, you cannot specify GrandTotal = Total + Total.) Click the Sum up fields box and type the name of one of the fields to be added. Then click Insert to add it to the combo box.
Click the box again and type the name of the next field to be added. Click Insert again, and the contents of the combo box are updated.
Continue as above until you have typed the names of all the fields that are to be included in the total. Do not forget to click Insert after you type the last field name.
You can view the contents of the combo box at any time by clicking the down arrow next to the Sum up fields box. To delete a field name from the list, select it and then click Delete from set. (Delete from set means to delete it from the set sum validation.)
In the Max. diff. box, specify the maximum difference allowed between the Total sum field and the Sum up fields.
Click OK.
Note: Only filled-in fields are included in set sum validations. If a field that you indicate as a sum up field is not filled in, this does not produce an error unless Must be filled in is selected for that field.