Help

Creating a database
F
ILEMAKER PRO HELP 196
Changing calculation formulas
When you change a calculation formula, FileMaker Pro recalculates the value for that field in all your
records. If you use the calculation field in any other calculation or summary field, FileMaker
Pro also
recalculates those fields.
To change a calculation formula:
1. With the database open, choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Fields tab.
3. If your database contains more than one table, select the appropriate table from the Table
list.
4. In the Fields tab of the Manage Database dialog box, select the calculation field, then click
Options.
5. In the Specify Calculation dialog box, make the changes you want.
See Defining calculation fields for information about the dialog box.
6. Click OK.
FileMaker Pro recalculates the formula when you close the Manage Database dialog box, and
displays a progress indicator if many records need to be reevaluated.
To change a calculation formula in Table View:
1. With the database open in Browse mode, click Table View in the layout bar.
2. Right-click the column heading for the calculation field and choose Field > Field Options
from the shortcut menu.
3. In the Specify Calculation dialog box, make the changes you want, then click OK.
Related topics
Working with formulas and functions
Changing summary fields
You can change summary fields; for example, to change the type of summary and the field you want
to group data by.
If you change the type of summary calculation, FileMaker Pro recalculates the value for every
record in the database when you exit the Manage Database dialog box.
A field used in a summary to a
field type that can't be used in a
summary
You see an alert. You must change the summary so it doesn't include
the field or delete the summary field before changing the field type.
A field used in a relationship You might not be able to change the field type if the field is used as a
match field in a relationship and the new field type cannot be used as a
match field in a relationship.
Container fields cannot be used as match fields. Fields with global
storage and summary fields cannot be used as key fields. Fields in
which indexing is disabled cannot be used as key fields.
When you change This happens