User manual

5-6 FileMaker Pro User’s Guide
Select comparison
and logical operators
Choose a
relationship
from the list
Choose field
references
Choose indexing and
Calculate only if at least one
Select mathematical
and text operators
Choose the way functions
are listed in the dialog box
Select
functions
Formula box
Choose a
formula
result type
Make the
calculated
field
repeating
field in the formula has a value
storage options
5. Select calculation options for the field.
To Do this
Select the data type of Choose a data type for Calculation result is <value>. Be
the result sure to choose the correct type for the result you want.
See “About choosing a field type” on page 5-4.
Make the calculated Select Repeating field with a maximum of
n values, type
field repeating the number of repetitions, then click OK. See “About
repeating fields” on page 5-11.
Perform the calculation Select Do not evaluate if all referenced fields are empty.
only when all
Clear this option if you always want FileMaker Pro to
referenced fields have
calculate a result, even if a referenced field is empty or
a value (so you don’t
has never been modified.
display zero as a result)
6. To select indexing and storage options for the field, click Storage
Options, select options, then click OK.
See “About storage and indexing options” on page 5-11.
7. Click OK to close the Specify Calculation dialog box.
8. Continue defining fields, or click Done.
For more information about defining calculation fields, see
FileMaker Pro Help. Choose Help menu > Contents and Index, click
the Index tab, and type calculation fields.
Defining summary fields
Use summary fields to calculate values across multiple records, like
subtotals, averages, and grand totals. For example, a summary field
can display the grand total of all sales in the month of May in a
report.
Tip Use the New Layout/Report assistant to quickly create a report
with grouped data (data in a summary field). See “About layouts and
reports” on page 6-1.
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,
whether the records are sorted, and which mode you are using.
If you’re modifying a layout that contains a summary field, you must
know about layout parts to get the results you want (see “About
layout parts” on page 6-25). For information about summarizing
related fields in portals, see “Summarizing data in portals” on
page 8-12.
1. Choose File menu > Define Fields.
2. In the Define Fields dialog box, for Field Name, type a unique name
for the field.
See “About naming fields” on page 5-3.
3. For Type, select Summary, then click Create.