Summary

Tony Coffman -

Summary

Adding summaries to your View will allow you to perform calculations on your selected group options. Please note that summaries should only be added to numeric fields and not strings.

To add a summary, select the desired report field in the summary dropdown list and click the button to apply the option.  Repeat to add additional summaries.  In the example below we are requesting a total Record Count and a summation of the Total Balances by Status Code.

The data will be summarized in the order the summary options are placed in the list box. To change the summary order, highlight the summary item by clicking on the appropriate value and then click the Move Summary Up or Move Summary Down buttons .  To remove a summary, highlight the summary item by clicking on the appropriate value, right click and click remove.

 

 

Summary Options

AVG                       Computes an average of the selected report field

COUNT                 Counts the total number of records

MAX                      Computes the maximum for the select report field

MIN                       Computes the minimum for the select report field

SUM                      Computes a summation of the selected report field

 

Have more questions? Submit a request

Comments

Powered by Zendesk