Filter
Top Products
The strings for each summary data are:
Summary Data Strings
First value *FIRST
Last value *LAST
Total *TOTAL
Average *AVG
Maximum value *MAX
Minimum value *MIN
Record count *CNT
You can press the F4 key on the
Text
prompt of the Define Text Detail display or
the Define Box Detail display to display the Select Field in Record Format display
as with the Design Record Layout display.
When you select a database file field on the Select field in Record Format display
and press the Enter key, the Define Text Detail display (or the Define Box Detail
display) appears with the selected field in the
Text data
prompt as follows:
Text data . . . . . . . . . . . &SALES(ᑍFIRST).
ᑍFIRST is the default summary function. You can show the Define Summary Data
display by pressing the F10 key, and change the summary function. You can also
specify an edit code for the summary data on the display.
Define Summary Data
Field . . . . . . . . . . : PRICE
Type choices, press Enter.
Summary function . . . . . . . . . ᑍFIRST ᑍFIRST, ᑍLAST, ᑍTOTAL, ᑍAVG
ᑍMAX, ᑍMIN, ᑍCNT
Numeric editing:
Edit code . . . . . . . . . . . 1-4, A-D, J-Q, X-Z
User-defined 5-9
Edit code modifier . . . . . . . 1=Asterisk fill
2=Floating currency symbol
F3=Exit F5=Refresh F12=Cancel
176 AFP Utilities for AS/400 User’s Guide