Adding Thousand seperators
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
Ganesshh_TL
6 - Meteoroid
‎08-23-2023
11:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to add thousand seperators without changing the datatype of the column to string. I want to kept the datatype of the column to be numeric.
Anyone please help me out to solve this.
Thanks in advance
Labels:
- Labels:
- Help
2 REPLIES 2
geraldo
13 - Pulsar
‎08-23-2023
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if the output is an excel file, you can use the report table and render tools. in the table tool, put decimal places and automatically leave the thousand separators and continue as numeric
16 - Nebula
‎08-23-2023
11:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Click the highlighted button to see thousand separators in the results pane.
If you're outputting to Tableau / Excel / other BI Tool, I would handle the thousand separator there.
In many other cases, you cannot add the a comma (a non-numerical value) and have the field still remain a string.
Hope this helps.
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)