User manual

88 | Creating databases
10. To select indexing and global storage options for the field, click Storage
Options, select options in the Storage Options dialog box, then click OK.
11. Click OK to close the Specify Calculation dialog box.
12. Continue to define fields, or click OK.
Note If your FileMaker Pro file accesses data from external ODBC data sources,
you can add supplemental fields to specify calculations using external data.
For more information about defining calculation fields, the use of context in
calculations, or supplemental fields, see Help.
Defining summary fields
Use summary fields to calculate values such as subtotals, averages, and grand
totals across multiple records. For example, a summary field can display in a
report the grand total of all sales in the month of May.
Tip Use the New Layout/Report assistant to quickly create a report with grouped
data (data in a summary field). See
“Creating layouts and reports” on page 98.
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’re using.
To Do this
Set the field type of
the result
Choose a data type for Calculation result is <value>. Choose the
correct type for the result you want. See “About choosing a field
type” on page 82.
Make a calculated
field repeating
Select Number of repetitions, then type the number of repetitions.
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.
When enabled, FileMaker Pro does not evaluate a calculation if all
fields used by the calculation are empty. This typically improves
performance. 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.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 88 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ