Numeric Range
The Numeric Range analytic test identifies transactions within a defined value range. Its main purpose is to flag high-value transactions, but you can adjust the configuration to detect transactions falling below a set threshold or within specific value ranges. You can also select to use percentage-based thresholds instead of numeric thresholds. For example, you can configure the test to identify the highest one percent of transactions.
This analytic test can be used to identify:
-
Transactions that contain significant estimates
-
Complex, non-routine or unusual business transactions that may warrant further investigation
-
Material transactions
-
Missing transactions which were potentially voided
-
Valuation issues
-
Material transactions from within the population
-
Low or zero value transactions from within the population
-
Zero value transactions or balances
-
A range of values such as just below a cut-off point
-
Debit accounts with credit transactions or credit accounts with debit transactions
-
Customers with large credit limits
-
Account receivable balances over a certain amount
-
Account payable balances over a certain amount
Fields used for analysis
This analysis uses one numeric field that contains either amounts or quantities. You can select which field to use when you set the test parameters.
Parameters
There are multiple parameters that must be set in order to run the test:
-
Select fields - Select one or more numeric fields from the list to use to perform the test.
-
Numeric or Percentage - Select whether to perform the test using the numeric value of the fields or percentage values. Numeric is selected by default. The option you select here determines what the remaining parameters are for this test.
If you select Numeric, make selections for the following parameters:
-
High value threshold - Enter a value in this field to extract all transactions with amounts higher than this value.
-
Low value threshold - Enter a value in this field to extract all transactions with amounts lower than this value.
-
Value ranges - Enter one or more value ranges to extract all transactions with amounts in these ranges.
-
Exact values - Enter an exact value to extract all transactions with that value. For example, you can use this parameter to extract all zero value transactions.
If you select Percentage, make selections for the following parameters:
-
High percentage threshold - Enter a percentage in this field to extract all transactions with percentages higher than this value.
-
Low percentage threshold - Enter a percentage in this field to extract all transactions with percentages lower than this value.
-
Value ranges - Enter one or more percentage ranges to extract all transactions with percentages in these ranges.
-
Exact values - Enter an exact percentage to extract all transactions with that percentage.
Test configurations
Note: The configurations available to you vary depending on the product you’re using.
The following configurations are available for this test:
-
Amount range - Identifies transactions within a defined range for amount fields based on a numeric value or a percentage value.
-
Discount range - Identifies transactions within a defined range for discount fields based on a numeric or a percentage value.
-
Quantity range - Identifies transactions within a defined range for quantity fields based on a numeric or a percentage value.
-
Due days range - Identifies transactions within a defined range for due days fields based on a numeric or a percentage value.
-
Numeric range - Identifies transactions within a defined range based on a numeric or a percentage value.
-
High monetary value - Identifies transactions where the amount field is greater than or equal to the defined numeric value.
Technical specifications
When you run the Numeric Range analytic test, the following steps are performed to run the test:
-
If needed place any filters on the data in order that a subset is used for the analysis. If no filter is placed, the analysis will be run on the entire data file. This step can also be performed as the last step instead of the first.
Note: Filters are not currently available and will be included in a later release.
-
Validate that the necessary reference fields have been selected. If fields have not been selected, then create a unique reference field. This step is only performed if specific fields have been selected. If all the fields are available, this step is not necessary.
-
Validate that the field selected to perform the test is numeric.
-
Based on the parameters selected by the user, determine the type of amount extraction:
-
Equal to the value
-
Greater than the value
-
Greater than and equal to the value
-
Less than the value
-
Less than and equal to the value
-
Not equal to the value
-
A range of values
-
-
Obtain from the user if the analytic will be based on a percentage or a value.
-
If value is selected then obtain the value from the user. If the option is range extraction then two values will be needed.
-
If a percentage is selected then obtain the percentage from the user and then calculate the value that the percentage represents. This will change depending on the type of extraction such as 10% for high values would give a different value than 10% for low values. If the option is range extraction then two values will be needed.
-
-
Extract the result fields selected by the user. All fields are extracted by default.
Note: The ability to select result fields is not currently available and will be included in a later release.