Field Name Description Field Shows the field name for which the summary function is being used. Summary function Shows the special value used to summarize the field values. The following summary function special values can be specified to print the summary data. *FIRST The first value in the specified field. *LAST The last value in the specified field. *TOTAL The total of the values in the specified field. This summary data is effective for numeric fields, excluding floating-point data. The number of integer digits of the total is the number of integer digits of the field plus three. For example, the total of the field whose integer digits are three and the fractional digits are two is printed as numeric data with six integer digits and two fractional digits. *AVG The average of the value in the specified field. This summary data is effective for numeric fields, excluding floating-point data. *MAX The maximum value in the specified field. *MIN The minimum value in the specified field. *CNT The record count. It is printed as an 8 digit integer. If there is a record whose field value is null, the record is not counted. Edit code Specifies the edit code in which the summary data is printed. The allowable edit codes (1-9, A-D, J-Q, X-Z) and their printout format are the same as those supported on DDS. If this parameter is not specified, the Print Format Utility prints the field based on the editing information defined by DDS or IDDU except for the record count. The Print Format Utility prints the record count with the leading zeros suppression by blanks if an edit code is not specified. Edit code modifier This parameter is optional. It is effective only when one of 1-4, A-D, and J-Q is specified on the edit code parameter. 1 An asterisk (*) is printed for each zero that is suppressed. A complete field of asterisks is printed for a zero balance field. 2 The currency symbol defined on the system value QCURSYM is printed on the left of the first significant digit. The symbol is not printed on a zero balance when an edit code is used that suppresses the zero balance. When you specify the above parameters and press the Enter key, the Define Text Detail display (or the Define Box Detail display) appears again. When you specify multiple summary data on the Text data prompt, the Select Fields to Define Summary Data display appears. You can select fields to change the summary function or specify an edit code on the display. The Define Summary Data display appears repeatedly for each selected field. If you specify break fields, you can print the summary data for each page break or for each page by specifying Y or N for the Print at page break only prompt on the Define Text Detail display (or the Define Box Detail display). The Print at page break only prompt appears at the bottom of the Detail display, and it appears only when 182 AFP Utilities for iSeries: User’s Guide