- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Thousands Separator with High Numbers
Hello! I have a Numeric Column which has up to 21 characters (i.e. 123145678915487615423) and I have the Column Properties set as:
Numeric
Continuous
Best
Width: 21
Use thousands separator checked
Unfortunately the highest character numbers are showing as 1.234567891546e+20
Where I want it to show as: 123,145,678,915,487,615,423
I tried to change many aspects, such as the modeling type, the format, data type, and the width.
Any help would be great! (I am using JMP17.0.0)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Thousands Separator with High Numbers
You can do that, sort of. You might not want to because you might be suggesting non-existent accuracy.
format(123456789101112131415161718192021,"Fixed Dec", Use thousands separator( 1 ), 60, 0)
// "123,456,789,101,112,139,099,124,663,320,576"
Notice there are only 15 to 16 significant digits; the remainder are garbage. This is a function of the IEEE 8-byte double precision floating point representation that can only represent an integer up to about 2^53==9007199254740992 (all 15 digit integers and most 16 digit integers.)
The 60, above, probably will break down around 100 as well. It does include the commas.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Thousands Separator with High Numbers
Isn't width =21 insufficient for what you want? I think (tell me if I'm wrong) that the commas count in the width. Also (and I think this is the main issue) change the "Best" to "Fixed Decimal" and it should work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Thousands Separator with High Numbers
@dale_lehman: I tried both of your fixes and it does not work
Thanks for the attempt!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Thousands Separator with High Numbers
It works for me - see attached.