Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

SIGN

SIGN

Returns whether a numeric value is positive, negative, or 0.

Syntax

SIGN(
numeric_value
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
numeric_value
Required
Numeric value. Passes the values you want to evaluate. You can enter any valid transformation expression.

Return Value

-1 for negative values.
0 for 0.
1 for positive values.
NULL if NULL.

Example

The following expression determines if the SALES port includes any negative values:
SIGN( SALES )
SALES
RETURN VALUE
100
1
-25.99
-1
0
0
NULL
NULL