Go to Contents  
Contents > Choosing the evaluation context for a calculation field
Choosing the evaluation context for a calculation field
Context is the table in the relationships graph from which a relationship is evaluated. When you define a calculation in a source table, and the table has more than one occurrence in the relationships graph, you must specify the context from which you want the calculation to evaluate.
Each context choice represents a different table in the relationships graph, and a different perspective into your data; when you choose the context for a calculation, you tell FileMaker Pro to evaluate the calculation starting from that table occurrence. Because each context choice represents a different association of related tables and fields, choosing the evaluation context for your calculation is critical to getting the results you expect.
An example of how context changes the results of a calculation
You have a database with two source tables named ColorsSourceTable and ShapesSourceTable. The tables have these properties:
Source table name Table occurrences in relationships graph Field names
ColorsSourceTable
ColorsTable 1, ColorsTable 2
Color
Style Number
Weight
ShapesSourceTable
ShapesTable
Shape
Style Number
Weight
Price
The tables are related as follows:

ColorsTable1 and ColorsTable2 have different relationships to the table ShapesTable
There are two separate relationships:
In the first, ColorsTable 1 and ShapesTable are related using the Style Number fields.
In the second, ColorsTable 2 and ShapesTable are related using the Weight fields.
Because ColorsTable 1 and ColorsTable 2 share the same source table, a calculation defined in ColorsSourceTable can be evaluated from the context of either the ColorsTable 1 table occurrence or the ColorsTable 2 table occurrence.
To see how this works, consider the effects of context on two calculation fields in the table ColorsSourceTable. Each calculation field uses the same formula to determine the sum of prices in the table ShapesSourceTable; the only change is the evaluation context. ShapesSourceTable has three records with these values:
Shape Style Number Weight Price
circle
100
5
$2.00
square
100
2
$6.00
triangle
200
2
$9.00
A single record in the ColorsSourceTable has these values:
Color Style Number Weight
red
100
2
Because the relationships use different match fields, each relationship returns a different set of related records.
Calculation result 1
The relationship between ColorsTable 1 and ShapesTable, which uses Style Number as the match field, returns these two records:
Shape Style Number Weight Price
circle
100
5
$2.00
square
100
2
$6.00
A calculation field defined in the ColorsSourceTable with the formula Sum(ShapesTable::Price) that is set to evaluate from the context of the table ColorsTable 1 returns the value $8.00.
Calculation result 2
The relationship between ColorsTable 2 and ShapesTable, which uses Weight as the match field, returns these two records:
Shape Style Number Weight Price
square
100
2
$6.00
triangle
200
2
$9.00
A second calculation field defined in the ColorsSourceTable with the same formula, Sum(ShapesTable::Price), but set to evaluate from the context of the table ColorsTable 2 returns the value $15.00.
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

Contents > Choosing the evaluation context for a calculation field