Skip to main content
Rounds the input number down to the largest integer of equal or lesser value. Category: math Syntax: 
Int([number_column])
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
numbernumber|column✓ YesThe number to be rounded down.
Allowed Column Types: INT, FLOAT, DECIMAL

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Int(3.6)
Rounds down to largest integer. Result: 3 
Int(-3.2)
Rounds down negative number. Result: -4 
Int([Cost])
Returns the Int for each row in the input column.
  • Sqrt - Calculate square root of a number
  • Sign - Determine if a number is positive, negative, or zero
Last modified on March 13, 2026