Help

FILEMAKER PRO HELP 1265
4. If the field you are summarizing is a repeating field, you have the option to summarize the
repetitions together or individually.
Select All together to calculate a single summary value for all repetitions in the field.
Select Individually to calculate a summary value for each repetition.
Note You must format your summary field as a repeating field to display individual summary
values. See
Setting up the display of repeating fields for more information.
5. Click OK.
Notes
• Summary fields are associated with groups of records. 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, and whether the records are sorted.
• Data in a summary field reflects records currently being browsed; either all the records or a
group of found records. If you change a value in one of the fields on which the summary is
based, or if you change the found set, FileMaker
Pro recalculates the result in a summary
field.
• When use the New Layout/Report assistant to create summary fields, you can create a
summary field for the current table only. To create a summary field for another table, see
Defining summary fields.
• If you choose Fraction of Total, you can specify a group field for Subtotaled. When you
return to Browse mode, you must sort by the group field to calculate the value correctly.
• The standard deviation formula is n-1 weighted, following the normal standard deviation.
• You can't change data in a summary field manually, but you can copy it. You can also
perform calculations with summary fields using the
GetSummary function.
• If your FileMaker Pro file accesses data from an ODBC data source, you can use
supplemental fields to define unstored calculations or summary instructions that act on data
coming from the external sources. For more information, see
Using supplemental fields.
Average of Weighted average. In the field list
that appears, select the field that
contains the weight factor.
Determine the average in one field
based on a value in another field
that is used as a weight factor.
Count of Running count Show the cumulative count of the
current and all previous records. To
restart the running count 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.
Standard Deviation of By population Calculate population standard
deviation.
Fraction of Total of Subtotaled. In the field list that
appears, select the field to group by.
Calculate a fraction of the total
based only on a group of records.
For Select To