A general operator that aggregates the values of all the records into a single record, displayed in a form view.
Group: Operators
Model level: iView
The following table describes the properties and attributes of this model element:
Group |
Property |
Attribute |
Description |
Sigma Operator |
Name |
Label for the operator |
|
Table at bottom |
(Data Type) |
Type of data in field |
|
Field |
Field whose data should be aggregated according to the Sigma attribute |
||
Sigma |
COUNT |
Totals the number of field values that are not blank |
|
MIN |
Returns the lowest field value |
||
MAX |
Returns the greatest field value |
||
SUM |
Returns the sum of all field values |
||
AVERAGE |
Returns the average (arithmetic mean) of the field values |
||
VARIANCE |
Estimates the variance based on the field values |
||
STDDEV |
Estimates standard deviation based on the field values |
||
[none] |