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.
3.
4.
5.
See Defining calculation fields for information about the dialog box.
6.
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.
2.
Right-click the column heading for the calculation field and choose Field > Field Options from the shortcut menu.
3.
Related topics 
Working with formulas and functions