Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.
To find a feature or item, use the Quick search bar.
For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight
decimalToInt
decimalToInt
converts a decimal value to the integer data type by stripping
off the decimal point and any numbers after it. decimalToInt
does not round
up. For example, decimalToInt(29.99)
returns 29
.
Syntax
decimalToInt(
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 converts a decimal field to an integer.
decimalToInt(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