Specifications

Four examples
632 InfoMaker
What you get
Here is the design for the report.
Here is the report showing eight descriptions, three of which are null and five
of which are not null. The last description for Id=8 is null.
Example 2: counting male and female employees
Example 1 demonstrates the use of the Sum and Count functions. Sum and
Count are two examples of a class of functions called aggregate functions.
An aggregate function is a function that operates on a range of values in a
column. The aggregate functions are:
Avg Large Mode Sum
Count Last Percent Var
CumulativePercent Max Small VarP
CumulativeSum Median StDev
First Min StDevP