FLOOR

Returns the nearest integer less than or equal to the specified value.

Sample usage

FLOOR(Height)

Syntax

FLOOR(X)

Parameters

  • X - a field or expression containing at least one field.

Note

  • FLOOR(X) is always less than or equal to X.

Examples

Formula Input Output
FLOOR(Height) 20.34 20
FLOOR(Height) -40.3 -41
FLOOR(Height) 50 50

Related resources

Was this helpful?
How can we improve it?
true
Get Looker Studio Pro

Upgrade now to get all the features of Looker Studio that you already know, plus enhanced enterprise capabilities and technical support

Search
Clear search
Close search
Google apps
Main menu
true
Search Help Center
true
true
true
true
true
102097