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.
Select this type of | 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.) |
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.
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. |
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.
•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 Advanced 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 Advanced 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.
•You can copy field schemas from one file and paste them into the same file or some other file. For more information, see Copying or moving fields between tables.