FIRSTNZ( )

 

Returns a Numeric Value
Returns the first non-zero value in a series of numeric expressions. Can have either two or three parameters. If all parameters have a value of zero, returns zero.

Examples:

FIRSTNZ(0,1,2)

Returns 1.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)