Computes the positive or negative sign of a given numeric value. The value can be a Decimal or Integer literal, a function returning Decimal or Integer, or a reference to a column containing numeric values.

Column reference example:

sign(MyInteger)

Output: Returns the sign of the value found in the MyInteger column.

Numeric literal example:

(sign(MyInteger) == -1)

Output: Returns true if the sign of the entry in the MyInteger column is -1

sign(numeric_value)


ArgumentRequired?Data TypeDescription
numeric_valueYDecimal or Integer Decimal or Integer literal, function returning Decimal or Integer, or name of column to apply to the function

numeric_value

Numeric literal, function returning numeric literal, or name of the column containg values the sign of which are to be computed.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal value-10.5

Example - Basic SIGN function

Source:

Your source data looks like the following, which measures coordinate distances from a fixed point on a grid:

XY
-24
-6.2-2
0-4.2
44
15-0.05

Transformation:

You can use the following transform to derive the sign values of these columns:

Using these two columns, you can assign each set of coordinates into a quadrant. For ease of reading, the following has been broken into two separate tranformations:

Then, you can merge the two columns together:

Results:

XYsignXsignYquadrant
-24-11upper-left
-6.2-2-1-1lower-left
0-4.20-1line
4411upper-right
15-0.051-1lower-right