A threshold is a numeric value that defines an acceptable margin of error for a test. You can enter a threshold for aggregate tests and for value tests with numeric datatypes.
An aggregate test fails if the number of non-matching records exceed the threshold value. For example, you run a COUNT test that uses the “≈” operator and set the threshold to 10. The test passes when the results are within 10 records of each other.
In a value test, the threshold defines the numeric margin of error used when comparing two values. For example, you run a VALUE test that uses the “=” operator. The test compares a REAL field with a value of 100.99 to an INTEGER field with a value of 101. The test passes when the threshold value is at least 0.01.
You can enter an absolute value or a percentage value as the threshold. To enter a percentage value as the threshold, suffix the number with a percentage (%) sign. For example, 0.1%.
You must configure the threshold if the test uses the approximate operator.