Creating the validation rule

You can create a validation rule to ensure that the grid total (Other_Charges_Total) equals the sum of the line item totals (Total).

1. On the Datacap Studio Rulemanager tab, in the Rulesets pane, select the Validate ruleset and click Lock/Unlock ruleset.
2. Right-click the Validate ruleset and choose Add Rule. Rename the new rule Validate Other Charges Total.
3. Under the Validate Other Charges Total rule, select Function 1.
4. On the Actions library tab, expand the Validations library. Select the CalculateFields action and click Add to function.
5. In the Rulesets pane, select the CalculateFields action. Then, in the Properties pane, set strParam as follows:

   'Total' = 'Other_Charges_Total'

6. Click Save, then click Lock/Unlock ruleset and choose Publish ruleset. Here is an example of the Validate Other Charges rule:
   • Validate Other Charges Total
     • Function1
       • CalculateFields("'Total' = 'Other_Charges_Total'")