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. |