CAS 6


avg
- Summary

Summary

Average value of a field or expression. (Statistical mean)

Examples

avg RATE
avg SPREAD plus INDEX
avg RATE (RATETYPE in 'F')

Syntax

avg NumericField (SelectionStatement)

Right Arguments

Name Data Type Input Type Description Optional Default
NumericField Numeric Field Numeric data field. No
SelectionStatement Boolean Field Expression to select records that will be applied to the calculation. Yes 1

Result

Type: Numeric

Statistical mean value.



Build 6.0.624