Free Trial

Alteryx Designer Desktop Discussions

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

Adding comma with text

kauser
8 - Asteroid

Hello, 

i am trying to add comma on a column and it has text as the end. how can i add comma to it.

 

current output 

 

F1F2
438752134234
46767698798
12323436756757
Total Sum689789

 

Expected Output

 

F1F2
43,875.002,134,234.00
46,767.00698,798.00
1,232,343.006,756,757.00
Total Sum

7,689,789.00

 

i also tried Toround, ToString and when i change column to double from string then i last line become Null from Total Sum. 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@kauser 
I just learned recently that we can add thousand seperator with ToString function.

1113-kauser.png

kauser
8 - Asteroid

@Qiu 

Thanks for your advice. its work but if there is decimal number then it wont work. can you please help to on input data below there data have decimal 

 

43875.452134234.34
46767.78698798.56
1232343.126756757.34
Total Sum689789.57
Qiu
21 - Polaris
21 - Polaris

@kauser 
I did not consider the decimal number since it was not in your sample.
maybe we can do something like this.

1113-kauser-r1.png

Labels
Top Solution Authors