Round off decimal places

[KrishnaChithrathil]

Can we make 2 decimal places to 6 decimal places without getting conversion errors in Alteryx?

Please find the screenshot below. 

I tried it with select tool, fixed decimal, with size 19.6 but i'm getting conversion error like this.

Select (4) Field1: "1.019879991124576532" has too many digits after the decimal and was truncated.

Whatever be the value, it should have 6 decimal places.

Any help?

[binuacs · Accepted solution]

@KrishnaChithrathil One way of doing this

[Emmanuel_G · Accepted solution]

@KrishnaChithrathil 

To can achieve this you can use Tostring function to format your digits as you want.

Here is the documentation about this function : Tostring function 

Please do not hesitate to mark this answer as solution if it helped.

[KrishnaChithrathil]

@binuacs 

That was neat. Thank you. 😊

[binuacs]

@KrishnaChithrathil 👍