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?