Help

FILEMAKER PRO HELP 1251
Notes
• When constructing a calculation formula, evaluation context determines which tables
appear as related and unrelated in the Specify Calculation dialog box.
• A calculation formula can use global fields from unrelated tables. These are the only fields
that can be used from unrelated tables.
Related topics
About relationships
Defining calculation fields
About formulas
Specify Calculation dialog box
This dialog box appears so that you can build a formula for a calculation or calculated field.
1. 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.
For more information on the use of context in calculations, see Choosing the evaluation context
for a calculation field.
2. 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:
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
tables list.
Note When the Specify Calculation dialog box opens from within
the Replace Field Contents and Send Mail dialog boxes, the tables
list may default to Current Layout (LayoutName) and display
only the visible fields on the current layout. To display all field
names from the current table, choose Current Table
(TableName) from the 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. For
information on each function, see
Functions reference
(alphabetical list), or Functions reference (category list).