We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Tostring fotmula

acarmi
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

Adiel

4 REPLIES 4
grazitti_sapna
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
Emil_Kos
17 - Castor
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)

 

Emil_Kos_0-1614243041542.png

 

Please mark my post as a solution if this was helpful.

 

It looks that I didn't understand the question correctly 😀

 

PhilipMannering
16 - Nebula
16 - Nebula

@grazitti_sapna is spot on here. To add to your understanding, the third argument is identified as True or False. 1 is True. But so is 2, 3 or 4 ... or even -1. The only number that evaluates to "False" is 0. Hope this helps.

anushree_bh
6 - Meteoroid

Thank you for solving my problem 

Labels