Return first non-zero value from list of fields or expressions
fnz 0 3 4
fnz 0 0
fnz CURBAL ORIGBAL
fnz MTDATE (FPDATE mplus ORIGTERM) (FPDATE3 plus 60)
fnz RATE1 RATE2 RATE3 RATE4
fnz Field1 Field2 Field3
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
Field1 | Numeric | Field, Constant | No | ||
Field2 | Numeric | Field, Constant | Yes | ||
Field3 | Numeric | Field, Constant | Yes |
Type: Numeric
Non-zero unless all fields are 0