Help

FILEMAKER PRO HELP 1252
• Tab to or click in the field, operators, or functions list.
• Type the first few letters of a field name, operator, or function to move to that item in the
list.
• Press Insert (Windows) or the Space bar (OS X) to place it in the formula box.
3. Select calculation options for the field.
4. To select indexing and storage options for the field, click Storage Options, select options in
the Storage Options dialog box, then click OK.
See Defining field indexing options and Defining global fields (fields with global storage).
5. Click OK.
Important To avoid confusion when using dates in FileMaker Pro, always define calculation
formulas to enter four-digit years. See Conversion of dates with two-digit years.
Notes
• You can type field names, operators, and functions in the Specify Calculation dialog box
instead of using the fields or operators lists.
• If you are using FileMaker Pro Advanced to customize menus, you can base a menu or
menu item title on the result of a calculation. You can also create tooltips based on a
calculation. See Defining custom menus (FileMaker Pro Advanced) and Adding tooltips on
layouts.
Related topics
About functions
About formulas
Adding a new line to the results of a formula
Adding comments to a formula
Changing calculation formulas
Defining calculation fields
Defining automatic data entry
Defining field validation
Defining field indexing options
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.
Make a calculated field
repeating
Select Number of repetitions, then type the number of repetitions.
See
Defining repeating fields.
Prevent calculation if all
referenced fields are empty
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.