About stratifying

Stratifying creates a profile of your data by grouping records into intervals based on a numeric field. You can count the number of records that fall into a specified number of equal or custom-sized intervals, and subtotal one or more fields for each interval. You can specify the minimum value of the first interval and the maximum value of the last interval and which fields to subtotal. Counts and totals for each interval are displayed as numbers and as percentages. Stratifying works on sorted and unsorted tables.

Stratifying in detail

Stratifying counts the number of records in a table and performs the following operations:

Table 1. Operations performed by stratifying


Location in Figure 1

Groups the records into intervals based on a numeric field

Trans Amount field, first

Subtotals the number of records falling into each interval, and calculates the percentage of the total count represented by each subtotal

Count field

Percent of Count field

Provides the minimum and maximum values in the numeric field being stratified

not shown

Optionally subtotals the values of one or more numeric fields for each interval, and for the first selected field calculates the percentage of the field total represented by each subtotal

Trans Amount field, second

Percent of Field field

Provides totals for all fields included in the output results

Totals row

Optionally breaks down the output results based on the values in a character field such as customer ID or transaction type (requires that the character field is sorted prior to stratifying)

not shown

Figure 1 provides an example of the results produced by stratifying on transaction amount in an accounts receivable table (the ‘Ar’ table in ACL DATA\Sample Data Files\Sample Project.ACL) and outputting the results to screen.

Figure 1. Stratify results

Related tasks
Stratifying data

(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback