Skip to main content

FLOOR Function

Computes the largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

Numeric literal example:

floor(2.5)

Output: Returns the value 2.

Expression example:

floor(MyValue + 2.5)

Output: Returns the largest integer that is less than the sum of 2.5 and the value in the MyValue column.

Syntax and Arguments

floor(numeric_value)

Argument

Required?

Data Type

Description

numeric_value

Y

string, decimal, or integer

Name of column or Decimal or Integer literal to apply to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

numeric_value

Name of the column, numeric literal, or numeric expression.

  • Missing input values generate missing results.

  • Literal numeric values should not be quoted. Quoted values are treated as strings.

  • Multiple columns and wildcards are not supported.

Usage Notes:

Required?

Data Type

Example Value

Yes

String (column reference) or Integer or Decimal literal

2.5

Examples

Tip

For additional examples, see Common Tasks.

Example - Exponential functions

This example demonstrates how the rounding functions work together.

Functions:

Item

Description

FLOOR Function

Computes the largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.

CEILING Function

Computes the ceiling of a value, which is the smallest integer that is greater than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.

ROUND Function

Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.

MOD Function

Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the % operator.

Source:

rowNum

X

1

-2.5

2

-1.2

3

0

4

1

5

1.5

6

2.5

7

3.9

8

4

9

4.1

10

11

Transformation:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

FLOOR(X)

Parameter: New column name

'floorX'

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

CEILING(X)

Parameter: New column name

'ceilingX'

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

ROUND (X)

Parameter: New column name

'roundX'

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

(X % 2)

Parameter: New column name

'modX'

Results:

rowNum

X

modX

roundX

ceilingX

floorX

1

-2.5

-2

-2

-3

2

-1.2

-1

-1

-2

3

0

0

0

0

0

4

1

1

1

1

1

5

1.5

2

2

1

6

2.5

3

3

2

7

3.9

4

4

3

8

4

0

4

4

4

9

4.1

4

5

4

10

11

1

11

11

11