intToDecimal - 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.