Help

Creating a database
F
ILEMAKER PRO HELP 174
4. For Field Name, type a name for the field.
See About naming fields.
5. For Type, select Calculation.
6. Click Create.
You see the Specify Calculation dialog box.
7. If necessary, for Evaluate this calculation from the context of, choose a table from the
list.
Setting the context for a calculation is only necessary when you're creating a calculation field in
a source table that has two or more occurrences in the relationships graph. The choice you
make may affect the calculation results, particularly if your calculation will include fields in
related tables. See Choosing the evaluation context for a calculation field.
8. Build a formula for your calculation.
Click where you want the item to appear in the formula box, then do the following. (You can also
type the formula into the box.)
To quickly build a formula:
• 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.
9. Select calculation options for the field.
To add a Do this
Reference to a field In the field list, double-click a field name.
To display field names from another table, choose a table from the
table list.
Mathematical or text operator For Operators, click a button or type an operator. See
Mathematical operators and Text operators.
Comparison or logical operator,
or an exponent
For Operators, double-click an operator in the list or type an
operator. See
Comparison operators and Logical operators.
Constant value Type the value.
Function In the functions list, double-click a function. In the formula box,
replace the placeholder parameter with a value or expression.
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.