U.M. (Windows)

Creating a database file 2-21
5. Select calculation options for the field.
To Do this
Make the calculated
field repeating
Click Repeating field with a maximum of n values, and then type the
maximum number (up to 1000) of repetitions you want.
Set the field type of the
result
For Calculation result is <value>, choose a field type for the result.
Be sure to choose the correct type for the result you want.
See fields from a
different file
Choose a filename from the relationship drop-down list. (For
more information about relationships, see “Understanding
relationships” on page 10-9.)
Have FileMaker Pro
perform a calculation
even when all
referenced fields have
no value (are empty)
Deselect Do not evaluate if all referenced fields are empty. (Do this
when you always want FileMaker Pro to calculate a result, even
if the field is empty or has never been modified.) Select this
option when you don’t want FileMaker Pro to evaluate the
calculation until one of the referenced fields has a value (so you
don’t display zero as a result).
Choose field references
Formula box
Select operators
Select functions
Choose a formula result type
Choose indexing
and result
storage options
Make a field repeating
Relationship drop-down list
Calculate only if at least one
field in the formula has a value