Progress
Report Builder
User’s Guide


Using Aggregates in Calculations

After you create an aggregate field, you cannot only use it in calculated field expressions, but also in other aggregates based on it. For example, if you create an aggregate field, Order-Total, that totals the Extended-Price for each customer order, you can create a calculated field to compute a five percent sales tax. You can also create a grand total of the Order-Total field to calculate the total of all the orders generated as the report is run.

The sales tax calculation based on the Order-Total field is typically placed in the corresponding group footer or, if each order is on a separate page, in a page footer band line.


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