Floor - Amazon QuickSight
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Floor

floor decrements a decimal value to the next lowest integer. For example, floor(29.08) returns 29.

Syntax

floor(decimal)

Arguments

decimal

A field that uses the decimal data type, a literal value like 17.62, or a call to another function that outputs a decimal.

Return type

Integer

Example

The following example decrements a decimal field to the next lowest integer.

floor(salesAmount)

The following are the given field values.

20.13 892.03 57.54

For these field values, the following values are returned.

20 892 57