Use that button to display the available aggregate functions.Aggregate
That property allows specifying the grouping function to be applied on the selected data field in the report.
Note: some aggregate functions cannot be applied to any field type. For example, for a character field, the SUM function cannot be used.
Use that button to display the available aggregate functions.
The Aggregate property uses the following parameters:
|
Parameter |
Example |
Description |
|
______________ |
________ |
__________________________________________ |
|
None |
Field |
Default value. No special aggregate function is applied. |
|
Sum |
sum(field) |
Returns the Sum of the concerned field |
|
Minimum |
min(field) |
Returns the Minimum value of the concerned field |
|
Maximum |
max(field) |
Returns the Maximum value of the concerned field |
|
Average |
avg(field) |
Returns the Average of the concerned field |
|
Count |
count(*) |
Returns the Number of record |
|
Variance |
var(field) |
Returns the Variance of the concerned field |
|
Population Variance |
varp(field) |
Returns the Population Variance of the concerned field |
|
Standard Deviation |
stdv(field) |
Returns the Standard Deviation of the concerned field |
|
Population Standard Deviation |
stdvp(field) |
Returns the Population Standard Deviation of the concerned field |