Round off decimal places

Question

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?

binu_acs · Accepted Answer

@KrishnaChithrathil One way of doing this

Emmanuel_G · Accepted Answer

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