SOLVED
Adding comma with text
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kauser
8 - Asteroid
‎11-12-2024
04:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
F1 | F2 |
43875 | 2134234 |
46767 | 698798 |
1232343 | 6756757 |
Total Sum | 689789 |
Expected Output
F1 | F2 |
43,875.00 | 2,134,234.00 |
46,767.00 | 698,798.00 |
1,232,343.00 | 6,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.
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Developer Tools
3 REPLIES 3
21 - Polaris
‎11-12-2024
04:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kauser
I just learned recently that we can add thousand seperator with ToString function.
‎11-13-2024
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.45 | 2134234.34 |
46767.78 | 698798.56 |
1232343.12 | 6756757.34 |
Total Sum | 689789.57 |
21 - Polaris
‎11-13-2024
03:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kauser
I did not consider the decimal number since it was not in your sample.
maybe we can do something like this.
