Below is a list of Aggregates functions, which can be used in expressions.
| Function | Description |
|---|---|
| Avg (value) |
This function shows the average value of a variable. If a variable average is in a footer section, it shows the average of all the values in the section above. If the variable is in the details section, it will show the average at each point in the list of values. |
| Count |
This function replaces the values of your variable with a numbered list. For example, in preview your report shows the following values for a variable: 32.1, 58.3 and 49.0. If you apply Count to that variable, your report will replace those values with: 1, 2, and 3. If the variable is in a footer section, it shows the total number of records. |
| CountIf (count) | Replaces value with a numbered list if it fits a condition. |
| Max (value) |
This function shows the maximum value of the variable. If the variable is in a footer section, it shows the maximum of all the values in the section above. If the variable is in the details section, it shows the variable's maximum value at each point in the list of values. |
| Min (value) |
This function shows the minimum value of the variable. If the variable is in a footer section, it shows the minimum of all the values in the section above. If the variable is in the details section, it shows the variable's minimum value at each point in the list of values. Note: To apply one of these functions to a variable, you can also use the Properties pane. |
| Sum (value) |
This function shows the sum of a variable. If the variable is in a footer section, it shows the total of all the values in the section above. If the variable is in a details or group header section, it shows the running total of the values on the report. |