For the complete documentation index, see llms.txt. This page is also available as Markdown.

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?