Skip to main content
Returns the sign of a number: -1 if negative, 1 if positive, 0 if zero. Category: math Syntax: 
Sign([number_column])
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
numbernumber|column✓ YesThe number or column of numbers to return the sign of.
Allowed Column Types: INT, FLOAT, DECIMAL

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Sign(-3)
Returns -1 for negative numbers. Result: -1 
Sign(3745)
Returns 1 for positive numbers. Result: 1 
Sign(0)
Returns 0 for zero. Result: 0
  • Int - Round down to nearest integer
Last modified on March 13, 2026