Defining summary fields
1.
2. In the Manage Database dialog box, click the Fields tab.
4. For Field Name, type a name for the field.
5.
6. Click Create.
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. Weighted average. In the field list that appears, select the field that contains the weight factor. 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. Subtotaled. In the field list that appears, select the field to group by.
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.Note You must format your summary field as a repeating field to display individual summary values. See Setting up the display of repeating fields.
10.
1.
2. Click + in the column heading to add a new field.
3. Right-click the column heading for the new field, then choose Field > Field Type > Summary from the shortcut menu.
•
• If you choose Fraction of Total of, 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.
•
•
• If you are using FileMaker Pro Advanced, you can copy field schemas from one file and paste them into the same file or some other file. See Copying and pasting field schemas (FileMaker Pro Advanced).