Including statistics in a custom AR System report

In a custom AR System report, you can use mathematical operations to build statistical data about the report such as counting the number of requests, or field-specific operations such as addition, average, and minimum.

Perform the following steps to configure the statistical operations to be performed in a custom AR System report:

1. Open the ReportCreator form, and click the Statistics tab.
2. From the Operation list, select the operation:
   • Count—Tallies the number of requests.
   • Sum—Adds up specified fields or the arithmetic relationship among fields.
   • Average—Calculates the average of specified fields.
   • Minimum—Calculates the minimum value for a specified field.
   • Maximum—Calculates the maximum value for a specified field.
     Except for Count, these operations can be applied only to numeric and date/time fields. Each operation can be applied to the whole report, or to a group of requests in a report. Groups are defined on the Sorting tab.
3. From the Expression list, select a field to be included as part of the statistic.
   An expression is required for all statistical operations, except Count. Whether you include an expression for a Count operation depends on how you want rows with null values to be counted.
   If you are defining a Count operation that includes an expression, only rows with a value that is not null for the specified expression are counted when the report is run. If you are defining a Count operation that does not include an expression, all rows returned are counted, including those with null values.
   The menu list displays all numeric or date fields in the form. Expressions can include any of the following values:
   • Numeric fields
   • Date fields
   • Status history fields
   • Keywords
     The most commonly used keywords are $DATE$, $NULL$, $TIME$, $TIMESTAMP$, $USER$, and $WEEKDAY$. Keywords are case-sensitive and must be entered in all capital letters.
     For reports to run properly in a browser, you must add a backslash to the keyword in the Expression field, for example, $\TIMESTAMP$.
   • Numbers
     You can type numbers directly into the Expression field, for example, 5.25, 33, and so on.
   • Arithmetic operators (+, -, **, */, and % )
     You can type arithmetic operators directly into the Expression field, similar to the way they are entered in the advanced search bar.

4. In the Label field, type the label to identify a statistic on the report. You can include any of the following control characters in a label field:
   

   \b	Backspace
   \n	Return
   \t	Tab
   \	Backslash
   \nnn	ASCII character

5. From the Compute On field, select the scope of the statistic:
   
   • Report—Calculates the statistic for all entries in the report. The statistic appears at the end of the report.
   • GroupN—Calculates a statistic for groups defined on the Sorting tab. The statistic appears below each group.
6. (Windows only) From the Layout list, select one of the following options to specify how you want the results to be displayed in the report:
   The Layout field setting works with the Compute On setting to determine where a statistic appears on a report. 
   • Single—Displays all the statistical results on one line.
   • Multiple—Displays each statistical result on its own line.
   • Column—Displays each statistical result at the bottom of the column (Field) that you specify in the Expression.
     Column layout is available only for a column-formatted report.

Where to go from here

Defining-custom-AR-System-reports