Calculate Field

Select a math operation to create a computed field.

In the Report Expression dialog box, choose Calculations, and then locate the Calculate field.

Information on the Report Expression dialog box is available in Report Expression.

Use the following options in the dialog box to build an expression for the report.

Choose this	To do this
Reset	Specify the point at which the expression is reset to its initial value. By default, End of Report is displayed. You can also select End of Page or End of Column. If you have specified groups in a report in the Data Grouping dialog box, Reset displays an item for each group in the report. Information on the Data Grouping dialog box is available in Data Grouping.
Nothing	For no calculations on this expression. (This is the default selection).
Count	Count the number of times a variable is printed per group, page, column, or report (depending on your selection in the Reset list). The calculation is based on the number of times the variable occurs, not on the variable's value.
Sum	Calculate the additive sum of the expression's values. This option keeps a running total of the expression values for a group, page, column, or report (depending on your selection in Reset).
Average	Calculate the arithmetic mean (average) of the expression values within a group, page, column, or report (depending on your selection in Reset).
Lowest	Display the lowest value that occurred in that expression for a group, page, column, or report (depending on your selection in Reset). Initially sets the expression's value equal to the value of the first record. When a lower value is encountered, the variable's value changes accordingly.
Highest	Display the highest value that occurred in that expression for a group, page, column, or report (depending on your selection in Reset). Initially sets the expression's value equal to the value of the first record. When a higher value is encountered, the expression's value changes accordingly.
Standard deviation	Return the square root of the variance for the expression values within a group, page, column, or report (depending on your selection in Reset).
Variance	Measure the degree to which individual field values vary from the average of all the values in the group, page, column, or report (depending on your selection in Reset).