User manual

48 FileMaker Pro User’s Guide
10. To select indexing and global storage options for the field, click
Storage Options, select options in the Storage Options dialog box, then
click
OK.
11. Click OK to close the Specify Calculation dialog box.
12. Continue to define fields, or click OK.
For more information about defining calculation fields and the use of
context in calculations, see Help.
Defining summary fields
Use summary fields to calculate values such as subtotals, averages,
and grand totals across multiple records. For example, a summary
field can display in a report the grand total of all sales in the month of
May.
Tip Use the New Layout/Report assistant to quickly create a report
with grouped data (data in a summary field). See “Creating layouts
and reports” on page 53.
The value in a summary field can change depending on where you
place the field on a layout, how many records are in the found set,
whether the records are sorted, and which mode you’re using.
If you’re modifying a layout that contains a summary field, you must
know about layout parts to get the results you want (see
“Working
with parts on a layout” on page 67).
1. With the database open, choose File menu > Define > Database.
2. In the Define Database dialog box, click the Fields tab.
3. If your file contains more than one table, select the appropriate
table from the
Table list.
4. For the Field Name box, type a name for the field.
See “About naming fields” on page 44.
5. For Type, select Summary, then click Create.
6. In the Options for Summary Field dialog box, select a summary
type, then select the name of the field you want to group by.
Select this type
of summary
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 the earliest date, time, or
timestamp for a field
Maximum Finding the highest number, or the 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. (The formula is n-1
weighted, following the normal standard deviation.)
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.
Choose a
summary type
Choose the
field you want
to group by
Select an
option for the
summary type
Select an option for summarizing repetitions
Restart the
total or count