Field Function Descriptions
The aggregate functions described in the following table are supported by all tables. If no values are available for the field on which an aggregate function is performed, a zero is returned.
|
Aggregate Function
|
Description
|
||
|---|---|---|---|
|
AvgField( FieldName )
|
Returns the average of all values stored in field.
|
||
|
MaxField( FieldName )
|
Returns the maximum value stored in field.
|
||
|
MinField( FieldName )
|
Returns the minimum value stored in field.
|
||
|
SumField( FieldName )
|
Returns the sum of all values stored in field.
|
||
|
|||
|
AvgTreeRollup( FieldName, UseSpecifiedValue)
|
Returns the average value of all values stored in field for all child records.
|
||
|
MaxTreeRollup( FieldName, UseSpecifiedValue)
|
Returns the maximum value stored in field for all child records.
|
||
|
MinTreeRollup( FieldName, UseSpecifiedValue)
|
Returns the minimum value stored in field for all child records.
|
||
|
SumTreeRollup( FieldName, UseSpecifiedValue)
|
Returns the sum of all values stored in field for all child records.
|
||
Functions are case-sensitive. Each function must be followed immediately by an open parenthesis. No space appears between the function name and the open parenthesis. A valid example follows:
MinField(Severity)
The table below shows three invalid examples.
|
Example
|
Error Description
|
|---|---|
|
MINFIELD(Severity)
|
Invalid case
|
|
MinField (Severity)
|
Invalid space after function name
|
|
minfield (severity)
|
Invalid case and space after function name
|
Automatic user calculations support aggregate functions, including tree rollup calculations. If you select Calculate Automatically in the Calculations pane for an equation that uses an aggregate function, this function is performed any time the result might change, such as when you modify, insert, delete, cut, paste, or import records.
 |
Because aggregate functions operate on multiple records, the execution time of automatic calculations increases as the number of records in your database increases. If you have many records, turning on automatic calculations for aggregate functions may make data entry time unacceptable. If this is the case, you should turn off automatic calculations for these functions.
|
After inserting an aggregate function calculation in the Calculation Editor pane, you click Verify to see if it is valid. If it is invalid, the window that opens provides an explanation. If a calculation that uses an aggregate function is found to be invalid at execution time, no window opens. The calculation is simply not executed.