Weighted Average of a field or expression excluding zero.
nzwa (2 0 4)
wa (2 0 4)
nzwa RATE CURBAL
nzwa ORIGRATE ORIGBAL
nzwa (SPREAD+INDEX) CURBAL
nzwa RATE CURBAL (RATETYPE in 'F')
nzwa NumField (Weight) (SelectionStatement)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| NumField | Numeric | Field | No | ||
| Weight | Numeric | Field | Yes | ||
| SelectionStatement | Boolean | Field | Expression to select records that will be applied to the calculation. | Yes | 1 |
Type: Numeric
Non-zero weighted average