Skip to main content
The Logical expression validator checks a numeric relationship between fields. It is how you catch documents where each field looks fine on its own but the numbers do not agree — a total that does not match its line items, a discount larger than the price.

Options

You build two expressions and choose how to compare them.

How it behaves

Because a missing value makes the check impossible to evaluate, pair this with Cannot be empty on the fields involved if they are required.
The comparison is numeric. Fields used in the expression should have a Numeric formatter so that values like 1 234,56 are turned into numbers before the check runs. Dates and text cannot be compared this way.
Totals rarely match to the last decimal once rounding is involved. If a strict = flags documents that are actually correct, compare against a small tolerance instead — for example check that the difference is ≤ 0.01.