/
FLOOR

FLOOR

Jan 30, 2018

Syntax

FLOOR(<number>;<number>)

Description

Rounds a number down, toward 0 (zero). The second value is the significance.

Examples

Column1

FLOOR() returns

Column1

FLOOR() returns

123.45

123

37.888

37

-5.5

-6


Add a significance value to round down from a specific decimal position. 

Column1

FLOOR(<column1>;3)

Column1

FLOOR(<column1>;3)

123.456789

123.456