Help

FILEMAKER PRO HELP 1264
summary fields in the subsummary part in the report. You can change the order of the
summary fields after you finish the assistant.
Related topics
Creating a layout
Options for Summary Field dialog box (New Layout/Report assistant)
If you clicked Add in the Specify Field dialog box, you can use the Options for Summary Field dialog
box to define a new summary field for this report from within the New Layout/Report assistant. If you
are defining summary fields outside the New Layout/Report assistant, see
Defining summary fields.
1. For Summary Field Name, type a name for the field.
See About naming fields.
2. From the list of fields, choose a field to summarize.
Note Fields with invalid field types are dimmed in the list based on the summary calculation you
selected.
3. Select a summary option, if applicable, for the summary type you chose.
Select this type of
summary calculation To summarize values in a field in the found set of records by
Total of Calculating the total of values in the field.
Average of Calculating the average of values in the field.
Count of Counting the number of records that contain a value for the field. For
example, if a field contains 100 values (one value for each record), the
result of the count is 100.
Minimum Finding the lowest number, or earliest date, time, or timestamp for a
field.
Maximum Finding the highest number, or latest date, time, or timestamp for a
field.
Standard Deviation of Finding how widely the values in a field differ from each other. This
option calculates the standard deviation from the mean of the values
in a field.
Fraction of Total of Calculating the ratio of the value in the field to the total of all the
values in that field. (For example, find what fraction of total sales can
be attributed to each salesperson.)
For Select To
Total of Running total Show the cumulative total for the
current and all previous records. To
restart the running total for each
sorted group, also select Restart
summary for each sorted group
and select the field upon which the
sort will be restarted from the field
list.