# Introduction to the Sum Check

Source: https://userguide.qualytics.io/data-quality-checks/sum/introduction/

*Requires the Data Quality (DQ) module.*

The Sum check asserts that a numeric column adds up to an exact total. It is an aggregate rule: it looks at the column as a whole rather than at individual rows, which makes it the rule for reconciling a load against a control total.

This section is the complete guide to the check. The Deep Dive covers the definition, properties, and full evaluation semantics, explains how anomalies are reported, walks through production examples, and collects best practices; the How-tos are step-by-step tutorials for creating, editing, and deleting a check; the API page documents the payload for programmatic use; and the FAQ answers the most frequent questions.

## Next Steps

- **How It Works**

  The complete reference: definition, field scope, the expected total, exact equality, NULL handling, filter behavior, and why coverage does not apply.

  [How It Works](https://userguide.qualytics.io/data-quality-checks/sum/deep-dive/how-it-works/)
- **Anomaly Reporting**

  The Shape Anomaly the check produces, what the numbers mean, and why there are no source records to inspect.

  [Anomaly Reporting](https://userguide.qualytics.io/data-quality-checks/sum/deep-dive/anomaly-reporting/)
- **Examples**

  Three production scenarios with sample data, the resulting anomaly message, and the SQL equivalent of what the check evaluates.

  [Examples](https://userguide.qualytics.io/data-quality-checks/sum/deep-dive/examples/)
- **Best Practices**

  Guidelines for control totals, scoping with a filter, and choosing between Sum and a per-row rule.

  [Best Practices](https://userguide.qualytics.io/data-quality-checks/sum/deep-dive/best-practices/)
- **Permissions**

  The team permission each action needs: view, create, edit, archive, restore, and delete.

  [Permissions](https://userguide.qualytics.io/data-quality-checks/sum/deep-dive/permissions/)
- **Create a Check**

  Step-by-step tutorial for creating a Sum check on a numeric field.

  [Create a Check](https://userguide.qualytics.io/data-quality-checks/sum/how-tos/create-a-check/)
- **Edit a Check**

  Step-by-step tutorial for changing the expected total or the filter on an existing check.

  [Edit a Check](https://userguide.qualytics.io/data-quality-checks/sum/how-tos/edit-a-check/)
- **Delete a Check**

  Step-by-step tutorial for archiving a check and deleting it permanently.

  [Delete a Check](https://userguide.qualytics.io/data-quality-checks/sum/how-tos/delete-a-check/)
- **Troubleshooting**

  Common problems with exact totals, floating-point arithmetic, filters, and aggregate anomaly reporting.

  [Troubleshooting](https://userguide.qualytics.io/data-quality-checks/sum/troubleshooting/)
- **API**

  Payload shape and field notes for creating a Sum check programmatically.

  [API](https://userguide.qualytics.io/data-quality-checks/sum/api/)
- **FAQ**

  Short answers to questions about the expected total, exact equality, NULLs, and anomaly reporting.

  [FAQ](https://userguide.qualytics.io/data-quality-checks/sum/faq/)

*Last updated: October 19, 2026.*
