User manual

5-6 FileMaker Pro User’s Guide
5. Select calculation options for the field.
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.
To Do this
Select the data type of
the result
Choose a data type for Calculation result is <value>. Be
sure to choose the correct type for the result you want.
See “About choosing a field type” on page 5-4.
Make the calculated
field repeating
Select Repeating field with a maximum of
n values, type
the number of repetitions, then click OK. See “About
repeating fields” on page 5-11.
Perform the calculation
only when all
referenced fields have
a value (so you don’t
display zero as a result)
Select Do not evaluate if all referenced fields are empty.
Clear this option if you always want FileMaker Pro to
calculate a result, even if a referenced field is empty or
has never been modified.
Choose field
references
Formula box
Select comparison
and logical operators
Select
functions
Choose a
formula
result type
Choose indexing and
storage options
Make the
calculated
field
repeating
Choose a
relationship
from the list
Calculate only if at least one
field in the formula has a value
Select mathematical
and text operators
Choose the way functions
are listed in the dialog box