All the value in two decimals

[Sshasnk]

I want to convert the number to 2 decimal places, for every number

Number

123

123.456

123.00

456.01

Number	Number_1
123	123.00
123.456	123.45
123.00	123.00
456.01234	456.01

[DavidSkaife]

Hi @Sshasnk 

Here is a way of doing it in one tool, use the Select tool to change the type to FixedDecimal:

[Christina_H]

You need to convert the number to a string: ToString([Number],2)

[grazitti_sapna]

@Sshasnk , If the data type is number then you can change it to fixed decimal and specify the precision and scale of the column. Below are more details on the fixed decimal data type usage:

https://help.alteryx.com/20223/designer/data-types#:~:text=Alteryx%20defaults%20a%20Fixed%20Decimal,....

[Sarreddy]

@Sshasnk