Skip to main content
Pentaho Documentation

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.