Summary functions

The following are functions that can be used for creating summaries.

• Count
  Total count of all the values in a field. The value will be shown in the Group Footer. For example, if you have six fields in a group, the value generated by Count will be 6.
• Sum
  This function sums up all the numerical values in a field. The value will be shown in the Group Footer. For example, if a field contains 5, 10, 15, 20 and 25, the Sum function will return 75.
• Minimum
  This function finds the smallest numerical value in a field. The value will be shown in the Group Footer. For example, if a field contains 5, 10, 15, 20, and 25, the Minimum function will return 5.
• Maximum
  This function finds the largest numerical value in a field. The value will be shown in the Group Footer. For example, if a field contains 5, 10, 15, 20, and 25, the Maximum function will return 25.
• Average
  This function takes the average of all the numerical values in a field. The value will be shown in the Group Footer. For example, if a field contains 5, 10, 15, 20, and 25, the Average function will return 15.
• Distinct Count
  This function takes a total count of all the distinct fields in a report. This value will be shown in the Report Footer. For example, if you have forty three fields in your report and three fields have identical values, the value generated by Distinct Count will be 41.
• Population Standard Deviation
  This function uses the following equation to compute its value. PSD takes the square root of the Population Variance.

  

• Standard Deviation
  This function uses the following equation to compute its value. SD takes the square root of the Variance.

  

• Population Variance
  This function uses the following equation. PV sums up the square of the difference between a value and its average, and then divides the result by the total number of values.

  

• Variance
  This function uses the following equation. Variance sums up the square of the difference between a value and its average, and then divides the result by the total number of values subtracted by one.