Specifications

CHAPTER 9 Filtering, Sorting, and Grouping Rows
Users Guide 311
The Modify Expression dialog box displays.
3 Specify the expression that defines the computed field (see below).
4 Click OK.
A shortcut to sum values
If you want to sum a numeric column, select the column in Design view and
click the Sum button in the Controls drop-down toolbar. InfoMaker
automatically places a computed field in the appropriate band.
Specifying the
expression
Typically, you use aggregate and other functions in your summary statistic.
InfoMaker lists functions you can use in the Functions box in the Modify
Expression dialog box. When you are defining a computed field in a group
header or trailer band, InfoMaker automatically lists forms of the functions that
reference the group:
You can paste these templates into the expression, then replace the #x that is
pasted in as the function argument with the appropriate column or expression.
For example, to count the employees in each department (group 1), specify this
expression in the group trailer band:
Count( Emp_Id for group 1 )
To get the average salary of employees in a department, specify:
Avg( Salary for group 1 )
To get the total salary of employees in a department, specify:
Sum( Salary for group 1 )