To add | Do this |
A reference to a field | Do one of the following: •Begin typing the field’s table, choose the table from the list, begin typing the field name, then choose the field name from the list the appears. •In the fields pane, double-click the field name. To display field names from a different table, choose the table from the tables list. |
An operator or an exponent | Do one of the following: •Type an operator. •Click an operator in the list to the right of the calculation pane. |
A constant value | Type the value. |
A function | Do one of the following: •Begin typing the function name, then choose a function name from the list that appears. •In the functions pane, double-click the function. In the calculation pane, 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 | For Number of repetitions, 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. |