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
Solved! Go to Solution.
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.
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)
Please mark my post as a solution if this was helpful.
It looks that I didn't understand the question correctly 😀
@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.
Thank you for solving my problem