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 |
Hi @Sshasnk
Here is a way of doing it in one tool, use the Select tool to change the type to FixedDecimal:
You need to convert the number to a string: ToString([Number],2)
@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: