Skip to Content

Calculation functions in the Reports Editor

The Reports Editor features arithmetic operators such as Sum, Average, Min, Max, Count and Standard Deviation. These operators can be entered via the context menu, called up from the cells in the Grand Total or Subtotal rows.

In List reports, the operators are placed in the Grand Total row, where they return the result of the calculation for all Format rows. They can also be placed in the subtotals rows; values will then be calculated for each set of Format rows, according to the sort criterion chosen. In Pivot table reports, operators are placed in the center row.

Sum Totals all values or sorted values.
Average Averages all values or sorted values.
Min Displays the smallest value among all values or among sorted values.
Max Displays the largest value among all values or among sorted values.
Count Displays the number of detail lines for the whole report or for the sorted set.
Standard Deviation Displays the square root of the variance of all or sorted values. The variance is a dispersion value around the mean.
Calculation functions in the Reports Editor