Specifying a summarization type

A summary view is one in which at least one column has been added to the Groupby list, as described in 'Adding fields to the Groupby list'.

To specify a summarization type

1. Right-click the column’s header or the field and choose Format data from the pop-up menu.

2. In the Format dialog, use the Summarization type radio buttons to specify a format type.The following table lists the summarization types and describes their calculations:

   Character	Calculation	Description
   A	Average	Average adds every value in a summarized numeric data field and shows the average.
   S	Sum	Sum adds every value in a summarized numeric data field and shows the total.
   M	Minimum	Minimum shows the smallest value in a summarized numeric or character data field.
   X	Maximum	Maximum shows the largest value in a summarized numeric or character data field.
   C	Count	Count counts the occurrences of a grouped value, which is either character or numeric, within a summarized data field.
   L	Any	Any summarizes on any characters in common. This summarization displays identical characters or numbers that repeat in the field data and indicates all other characters with an *. Warning Example In a summarized view of a list of jobs, you might have a row of data for PR**** jobs and another one for P***** jobs (jobs that start with P, but not with PR).
   P	Percentage	Percent adds the values in a summarized numeric field and shows the total as a percentage in relation to the total of all values for all data fields.

   After you make your selection, the data view in the field changes to the new view. You can select and clear the radio buttons to toggle between views and determine which one you prefer.

   When Summarization type is set to count, you can optionally specify a condition in the Condition field; use this field to count only rows that meet the specified condition, or to exclude certain rows from summarization (such as any fields having a zero value).

   A condition might be regarded as:

   • A relational operator (>, >=, <, <=, or =) and a value

   • A range that uses the BETWEEN operator and a value

     The format of the BETWEEN operator is ><(value1, value2).

   The rules for the value must conform to the following guidelines:

   • The value can be numeric or alphanumeric.
   • The value can use the * and ? wildcard characters. The * indicates one or more characters, and ? indicates a single character. The * can be used alone and is the default.
   • The value cannot be the column ID of another field.

   Warning

   Example

   • To define a condition of any value in the current field, specify =*.
   • To define a condition of all values exceeding 25 in the current field, specify >25.
   • To define a condition that is a range of values for the current field that are greater than or equal to the low value (5) and are less than or equal to the high value (25), specify ><(5,25). (This example illustrates the BETWEEN operator.)
3. When finished, click OK.The view is now customized. When you close the view, MainView Explorer prompts you to save your changes. If you decline, the customizations will not be retained.