topic Re: Thousands Separator with High Numbers in Discussions

Thousands Separator with High Numbers

Maerawlings — Mon, 31 Jul 2023 15:24:47 GMT

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)

Re: Thousands Separator with High Numbers

Craige_Hales — Mon, 31 Jul 2023 15:49:58 GMT

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.

Re: Thousands Separator with High Numbers

dale_lehman — Mon, 31 Jul 2023 17:11:53 GMT

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.

Re: Thousands Separator with High Numbers

Maerawlings — Mon, 31 Jul 2023 17:18:57 GMT

@dale_lehman: I tried both of your fixes and it does not work :( the characters are giving incorrect values when I use these fixes and the thousands separator does not show up.

Thanks for the attempt!

Re: Thousands Separator with High Numbers

dale_lehman — Mon, 31 Jul 2023 17:24:02 GMT

It works for me - see attached.