You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.

FLOOR

The FLOOR function rounds an input value to the nearest integer that is less than it.

Syntax

SELECT FLOOR(…)
FLOOR(constant)
FLOOR(fact)
FLOOR(metric)
FLOOR(metric_expression)

Examples

SELECT FLOOR(12.2) = 12
SELECT FLOOR(12.7) = 12