IFF(test_exp, true_exp, false_exp)

 

Returns a Numeric Value
Returns the value of true_exp if test_exp is true (non-zero). Otherwise, returns false_exp if test_exp is false (zero). Use this function to return numeric values. Use the IFF$( ) function to return alpha values.

Examples:

IFF(Total_Balance > 500,1,0)

Returns 1 assuming Amount Due is $750.00.

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)