Summary Functions

These functions allow you to create a summary for a selected field. 

• Count: This function will give a total count of all the values in a field.  This 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.
  Note: This is the only function for letter and word values.
  
  
• Sum: This function sums up all the numerical values in a field.  This value will be shown in the Group Footer. 
  For example, if a field contains 5, 10, 15, 20, and 25, the Sum function will compute 75.
  
  
• Minimum: This function will find the smallest numerical value in a field.  This value will be shown in the Group Footer.
  For example, if a field contains 5, 10, 15, 20, and 25, the Minimum function will compute 5
  
  
• Maximum: This function will find the largest numerical value in a field.  This value will be shown in the Group Footer.
  For example, if a field contains 5, 10, 15, 20, and 25, the Maximum function will compute 25
  
  
• Average: This function will take the average of all the numerical values in a field.  This value will be shown in the Group Footer.
  For example, if a field contains 5, 10, 15, 20, and 25, the Average function will compute 15.
  
  
• Distinct Count:  This function will take 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 the Distinct Count will be 41.
  
  
• Population Standard Deviation: This function will use the following equation to compute its value.  PSD takes the square root of the Population Variance.
  
  
  
  
• Standard Deviation: This function will use the following equation to compute its value.  SD takes the square root of the Variance.
  
  
  
  
  
• Population Variance: This function will use the following equation.  PV sums up the square of the difference between a value and its average and divides it by the total number of values.
  
  
  
  
• Variance: This function will use the following equation.  Variance sums up the square of the difference between a value and its average and divides it by the total number of values subtracted by one.