Running Functions
The Running category contains mathematical functions that deal with running totals, as opposed to global or summary totals.
| Function Name | Purpose |
|---|---|
| Sum | Calculates a running total sum of the specified column. |
| Count | Counts the items in a group or report. |
| Group Count | Counts the number of groups in a report. |
| Count Distinct | Counts the distinct occurrences of a certain value in a column. |
| Average | Calculates the average value in a given column. |
| Minimum | Identifies the lowest or smallest value in a column. |
| Maximum | Identifies the highest or largest value in a column. |
| Percent of Total | Calculates the percentage value of a numeric column. The total sum is divided by the number of items counted. |