Changing calculation formulas

Contents > Creating a database > Changing field definitions > Changing calculation formulas

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.

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.

Related topic

Working with formulas and functions

Contents > Creating a database > Changing field definitions > Changing calculation formulas