Progress
Results User’s Guide
for UNIX
Adding a Percent of Total to a Report
This section describes how to define a percent of total field in a report. For example, you can add a field that displays the percent of total items represented by each line in the report.
- Select the Define option, then select the Percent of Total option.
The window displays a list of all the numeric fields in the files you have selected. You can use them for the Percent of Total field.
- Select the field you want to use to define a percent of total.
A window appears that enables you to rename the label that will appear above the column in the report. It also enables you to redefine the format for the field. Your window might look like this:
![]()
This window contains these fields:
- File—Displayed as Percent of Total because Results generated it. (It is not contained in any database file.)
- Field—The name Results automatically assigns to the field you are creating; this field name will be in the list with the other field names once you add the new field.
- Expression—Displays the field (and the database and file it came from) that is used as a basis for the percent of total.
- Type—The data type. In this case, the data type is in decimal format.
- Label—Shows the default text that appears above the column in the report, which is% Total by default in this case. You can change the label to a more descriptive name for your report.
- Format—Shows the default display format. In this case, the default format is ->>>9.9%. For more information about formats, see "Field Display Formats."
- Enter a new label and format and hide repeating values.
- Press GO to enter the new field into the Report Layout window.
The new field appears in the layout window, and a
*p
marker under the format indicates that it is a percentage field.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |