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 Table View button 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
Was this topic helpful? Send feedback.