Sometimes, you may want to exclude one or more boxes from a calculation. For example, a headcount calculation should not include vacant positions.
To exclude fields from calculations:
1 Select the boxes that you want to exclude from a calculation.
2 Click the Format tab and select Layout, then click the Advanced tab.
The Box Properties dialog box Advanced tab is displayed.
3 Complete your selections as follows:
· Exclude from Calculations: Select a set of fields to exclude from calculated functions.
· Exclude from Counts: Select this option to exclude a box from count functions.
4 Click OK to save your changes and close the dialog box.