FLOOR

FLOOR(value)[source]

Rounds a number or array of numbers down to the nearest integer.

The FLOOR function evaluates the input value and returns the largest integer less than or equal to it. If an array of numbers is provided, each element is rounded down individually. If the input is blank or in an error state, the formula evaluates to an error.

Parameters:

value (Operand | float) –

The number or array of numbers to compute the floor of. If blank or in an error state, the formula will evaluate to an error.

Supported types:

  • DECIMAL

  • DECIMAL_ARRAY

Return type:

Formula

Returns:

The integer value(s) representing the floor of the input. The result matches the input type: scalar input returns a single integer, array input returns an integer array.

Supported types:

  • INTEGER

  • INTEGER_ARRAY

Raises:

ValueError – If value is not of type DECIMAL or DECIMAL_ARRAY.

Examples

Rounding a single value:

ROUND(3.6)
# Returns 3

Rounding an array of values:

ROUND([1.2, 3.0, 4.5])
# Returns [1, 3, 4]