Use this window to define calculated columns that you may select from the Available Columns list on the Data Layout tab in Options.
Highlight a column in Selectable Columns.
Use the Operators and Numbers or another column to add calculations to the formula.
You may also use functions. (Refer to Help System for details.)
The Format dropdown enables you to define the decimals to be used.
The Filters function allows you to create a filtered calculated column. From the Filters drop-down list, select the applicable filter. The list of filters is based on saved advanced filters on the filters tab. The calculation will only be applied to rows that pass the filter.
Click in the Global Value checkbox to create a calculation that can be used as a global total. The value is summed up for the entire report and can be used in other calculations.
From the For Group drop-down list, select the group for which you want to perform calculations for each member of the group separately.
Type a name for your calculation
You have two choices for saving.
<Save> stores your personal calculations.
<Save as System> stores as system calculations that you may share with others.