U.M. (Mac OS)

Creating a database file 2-23
Keep these points in mind:
1 When you type values, expressions, functions, and parameters, the
letters can be uppercase or lowercase. FileMaker Pro doesn’t
consider case for calculation purposes.
1 When you use a repeating field in a calculation, the other parts of the
formula must be compatible with that field.
Defining summary fields
Important The value in a summary field depends on the layout part in
which you place the summary field, so you must know about parts and
summary parts to get the results you want. Before you define a summary
field, see “Working with layout parts” on page 3-24 and “About
summary layout parts” on page 3-29.
1. Create a new file, or choose Define from the File menu and then
choose Fields.
2. In the Define Fields dialog box, for Field Name, type a name for the
field.
3. For Type, select Summary, and then click Create.
4. In the Options for Summary Field dialog box, select the type of
summary to perform, and then select the name of the field that
contains the values to summarize.
Choose FileMaker Help Index from the or Help menu, and then type:
E calculation fields
To summarize values in a field in the found set
of records by Select
Calculating the total of values in the field Total of
Calculating the average of values in the field Average of
Counting the number of records that contain a value for the field Count of
Finding the lowest number, or the earliest date or time, for a field Minimum
Finding the highest number, or the latest date or time, for a field Maximum
Calculating the standard deviation from the mean of the values in
a field. (The formula is n-1 weighted, following the normal
standard deviation. For population standard deviation, see step 5.)
Standard Deviation 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 individual sales person.)
Fraction of Total of
?