Calculate Field Dialog Box

  • Article

Makes it possible for you to select a mathematical operation to create a computed field. This dialog box is displayed when you choose Calculations in the Report Expression dialog box.

  • Reset
    Makes it possible for you to specify the point at which the expression is reset to its initial value. By default, End of Report is displayed in the list box. 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, the Reset box displays an item for each group in the report.

Calculate

These options make it possible for you to specify a calculation performed on the report expression.

  • Nothing
    Specifies that no calculations be made on this expression. (Default)
  • Count
    Counts 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
    Computes 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 the Reset box).
  • Average
    Computes the arithmetic mean (average) of the expression values within a group, page, column, or report (depending on your selection in the Reset box).
  • Lowest
    Displays the lowest value that occurred in that expression for a group, page, column, or report (depending on your selection in the Reset list). 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
    Displays the highest value that occurred in that expression for a group, page, column, or report (depending on your selection in the Reset box). 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
    Returns the square root of the variance for the expression values within a group, page, column, or report (depending on your selection in the Reset box).
  • Variance
    Measures 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 the Reset box).

See Also

Data Grouping Dialog Box | Report Designer | Report Expression Dialog Box | Report Designer Band Dialog Boxes