Running functions

Pentaho Report Designer

Part Number

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.