User Tools

Site Tools


syntax:functions:iserror

IsError(expression)

Returns TRUE if result of expression is an error. Otherwise returns FALSE.

Example FieldA Result Remarks
IsError( 100 / [FieldA] ) 200 FALSE
IsError( 100 / [FieldA] ) 0 TRUE Error - division by zero
IsError( left([FieldA], 'ZZZ') ) Red TRUE Error - Inappropriate parameter
syntax/functions/iserror.txt · Last modified: 2015/04/03 22:54 by elenap