VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] نسخه متنی

Using Counts and Averages

Using an existing report with summary fields as a basis, you can easily add counts and averages. For example, if you have summary fields that track individual sales, total sales, and state sales tax, you can duplicate the summary total fields and rename them. In the copy, you change the calculation result to add a summary field that counts the number of sales and the average sale amount.

To create counts and averages with a summarized layout

1. Choose File > Define > Database (Control+Shift+D/Command+Shift+D).

2. When the Define Database dialog box appears, click the Fields tab.

3. Duplicate the summary field that holds the total amount of the field you want to average (in this example, it's the Sale Amount Summary field). Change its name to something unique. Click Create (Figure 5.23).

4. Double-click the new field. When the Options dialog box appears, click the "Average of" radio button (Figure 5.24). Click OK.

5. To create another summary field that counts the number of sales, repeat steps 1-3. This time click the "Count of" radio button in the Options dialog box. Click OK to close the dialog box, then OK again.

6. In Layout mode, choose the layout that will display the new fields. If it doesn't already have a Trailing Grand Summary part, create one by dragging the Part tool into the layout and choosing the Trailing Grand Summary radio button in the Part Definition dialog box. If the layout already has a Trailing Grand Summary part, click the bottom of the part and drag down to make room for the new fields.

7. Drag the Field tool into the Trailing Grand Summary part and add the Sale Amount Average field to display the average of all sales in the report (Figure 5.25). Click OK.

8. Drag the Field tool into the Trailing Grand Summary part again, and add the Count field to display the number of individual sales in the report. Click OK.