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 |