Table of Contents

, ,

SIGN

Description

Returns the sign of the provided number (0, 1 or –1)

Syntax

SIGN (number)

Can be used in the condition of a FIND action.

Parameters

Attribute of the Number type or number constant or calculation producing number

Returns

Number: the sign of the number: 0, 1 or -1.

Example

IF SIGN (Transaction.Amount) = -1 THEN ... 

ABS, NEG