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.
Last updated
Was this helpful?