• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Creating Data Reports > Using Counts and Averages

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, rename them and change their 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 summary layout:

1.
Choose File > Define Fields (Ctrl+Shift+D/Command-Shift-D).

2.
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 Save (Figure 5.17).

Figure 5.17. Duplicate the existing summary field, rename it and change its calculation result from Total of to Average of.


3.
Double-click on the new field. When the Options dialog box appears, click the Average of radio button (Figure 5.18). Click OK.

Figure 5.18. Duplicating an existing field and changing the calculation saves time in creating a summary field.


4.
To create another summary field that counts the number of sales, repeat steps 1 and 2. This time click the Count of radio button in the Options dialog box. Click Done to close the dialog box.

5.
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 to the layout and choosing the Trailing Grand Summary radio button from the Part Definition dialog box. If this part already appears in the layout, click the bottom of the part and drag down to make room for the new fields.

6.
Drag the Field tool to the Trailing Grand Summary part and add the Average field to display the average of all sales in the report (Figure 5.19). Click OK.

Figure 5.19. Add the Sale Amount Average to the Trailing Grand Summary part to display the average of all sales in the report.


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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint