Help

Creating a database
F
ILEMAKER PRO HELP 177
8. Select a summary option, if applicable, for the summary type.
9. 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.
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.)
List of Creating a return-delimited list of non-blank values in a field.
Select this type of
summary calculation
To summarize values in a field in the found set of records by
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.
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.