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
intToDecimal
intToDecimal
converts an integer value to the decimal data type.
Syntax
intToDecimal(
integer
)
Arguments
- int
-
A field that uses the integer data type, a literal value like
14
, or a call to another function that outputs an integer.
Return type
Decimal
Example
The following example converts an integer field to a decimal.
intToDecimal(price)
The following are the given field values.
20 892 57
For these field values, the following values are returned.
20.0 892.0 58.0
You can apply formatting inside an analysis, for example to format
price
as currency.