User manual

44 FileMaker Pro User’s Guide
7. Select an option, if applicable, for the summary type.
Options change according to the summary type you select in the
previous step.
8. Select an option, if applicable, for summarizing a repeating field.
9. Click OK.
10. Continue to define fields, or click OK.
For more information about defining fields, see Help.
Setting options for fields
You can set field options when you define a field, or at a later time.
You can set options for:
1 entering default data into a field
1 checking data against validation requirements
1 making a repeating field
1 creating an index
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 this
summary type Select To
Total of Running total Show the cumulative
total for the current and
all previous records
Average of Weighted average. In the
list of fields that appears,
select the field that contains
the weight factor
Determine the average in
one field based on a value
in another field that’s
used as a weight factor
Count of Running count Show the cumulative
count of the current and
all previous records
Select this type
of summary
To summarize values in a field
in the found set of records by
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
Standard Deviation of by population Calculate population
standard deviation, where
the formula is n-weighted
Fraction of Total of Subtotaled. In the list of
fields that appears, select a
field to group by. (When
you return to Browse mode,
sort by this field to calculate
the value correctly.)
Calculate a fraction of the
total based only on a
group of records
Select To
All together Calculate a single summary value for all repetitions in
the field
Individually Calculate a summary value for each repetition
For this
summary type Select To