Remove commas from numeric field in report
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I hope someone can help. I'm trying to remove commas from a numeric field that I'm emailing to a list of individuals using the layout and render reporting tools. I don't see the commas in the workflow, but when I open up the excel spreadsheet I see them. I've tried other suggestions like the replacing comma with blanks, removing commas from localization, and I can't figure out how to do this using the data cleansing tool. Does anyone have any other suggestions?
Thank you
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hey @JennyRuns24 do you have some sample figures we can experiment with?
I would usually use a formula like this on the data before doing any reporting:
ToNumber(Replace([Numbers], ",", ""))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm assuming you are using a table tool before the layout and render? The Table Tool adds commas no matter what, and as far as I know there is no way to turn that off.
To accomplish what you want I think you'll need to unfortunately go against the grain and format your numeric field as text. Look into using the ToString Field.
