Changing calculation formulasWhen 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.
1.
2. In the Manage Database dialog box, click the Fields tab.
4. 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.
1.
2. Right-click the column heading for the calculation field and choose Field > Field Options from the shortcut menu.