We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

alteryx Community

# Alteryx Designer Discussions

SOLVED

## Tostring fotmula

5 - Atom

Hi

can you help me understand the Tostring formula?

i want to convert a number so it will be presented with comma separator for thousands.

in the training i saw the answer is:

ToString([Total], 2,1)

but I want to understand the meaning of the '1' in the formula because when I tried to change it to 2,3,4 etc. it keeping the same.

thanks a lot

3 REPLIES 3
17 - Castor

Hi @acarmi , you can refer to this link for better understanding.

https://help.alteryx.com/current/designer/conversion-functions

But according to me for thousand separator only 0 or 1 works where 0=False without thousand separator and 1=True with thousand separator.

In case this helps, please mark this post as solution.

Thanks.

Sapna Gupta
17 - Castor

Hi @acarmi,

it is related to decimal places. Here we have 2 diffrent columns one with 1 decimal place and second with 3 decimal places:

Test decimal 1

ToString([Field1], 1)

Test decimal 3

ToString([Field1], 3)