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

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

Related resources

• Calculated fields
• Looker Studio function list