Progress
Results User’s Guide
for Windows


Calculated Fields

So far you have displayed fields that already exist in the database. However, you can create your own column of data, called calculated fields, to help you analyze the information in your query.

For example, you can create a field called Total Price that automatically multiplies the price of each item a customer orders by the number of items ordered, as shown in the following figure:

Calculated fields are display fields only, so neither the field nor its contents are saved to the database. Table 6–1 shows the types of calculated fields you can create.

Table 6–1: Calculated Fields
Calculated Field Types
Description
Availability
Percent of Total
Expresses the percent of total that the value of a field represents within the query. For example, you can display the percent of total for each sales representative’s monthly sales figures.
Available in the Report and Export views only.
Running Total
Displays the running total of any numeric field or expression. A running total increments for each line of the query. That is, the value displayed in that column on any line in the query is the sum of the field value for that and all previous lines in the query. For example, if the value in the first record is 1 and the value in the second record is 3, the running total for the first line is 1 and the running total for the second record is 4 (1 plus 3).
Available in the Report and Export views only.
Counter
Displays a running counter. Use counters for line numbering and counting records.
Available in the Report and Export views only.
Stacked Array
Displays the elements in an array in a vertical column.
Available in the Report view only.
Lookup
Displays the value of a field from a table not included in the query.
Available in all the query views except Labels.
Math
Defines a math expression based on the value of one or more fields. Use the following operations to calculate the value of the two fields: add, subtract, multiply, divide, or raise to a power. For example, you can create a field named Total Price to multiply the value of the Price and Qty fields for each record in the query.
Available in all views.
String Function
Defines a display field based on a string expression.
Available in all views.
Numeric Function
Defines a display field based on a numeric expression.
Available in all views.
Date Function
Defines a display field based on a date calculation.
Available in all views.
Logical Function
Defines a logical display field based on the value of one or more fields in the query.
Available in all views.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095