Field Sum

Check all values sum to a given value

Select this check box to check that the sum of a list of fields on a single record is equal to a given value in a specified tolerance.

Table

Select the table containing the values to be checked.

Fields to sum

Click the Browse button to specify the fields to sum. Once selected, the Fields to sum panel displays

Select the fields to sum and specify the null values.

All fields set

Select this check box to fail the validation if one or more fields are blank or equal to the null value specified.

Sum

Enter the value that the sum of all fields must equal to.

Tolerance

Enter a tolerance for the sum value. The validation will fail if the sum of all fields is outside the specified tolerance. For example you are summing field A and field B, and the total should be 100.0; and you have entered a tolerance of 0.5. If A is 30, and B 70.6, then this sums to 100.6 which is not 99.5 <= val <= 100.5, so it will show up in the report as a failure.

---

Related topics

• Validation Specifications
• Select Database
• Collar Checks
• Unique Collar Location
• Collar on Surface
• Downhole Checks
• Empty Table
• Total Depth
• Overlapping Intervals
• Increasing and Decreasing
• Maximum Variation
• Unique Values
• Sequence
• Derived Value
• Along Record Checks
• Field Sum
• Individual Field Checks
• Minimum and Maximum
• Translations
• Case Of
• Mandatory
• Expression
• Report
• Save and Run