Search Results for

    Show / Hide Table of Contents

    Using functions

    In our example we see the sum of each employee’s salary over four years in the “Total” line. Any of the following aggregate functions can be used:

    SUM – sum of values

    MIN – minimal value

    MAX – maximal value

    AVG – average value

    COUNT – number of values

    Let’s use the MIN function in our example. Open the cross-tab editor and click the arrow next to the “Salary” field item.

    Select the “Min” function from the drop-down list. Now we can change the text in the total cells from “Total” to “Minimum.” The finished report looks like this:

    Back to top © Copyright Fast Reports Inc.