topic Re: '003338366400' converts to 2147483647 in Dashboards & Analytics Discussions

'003338366400' converts to 2147483647

RADSr — Wed, 17 Aug 2022 18:59:39 GMT

I think I've seen this before and asked on the old community, but how can I get a value such as this string

'003338366400' to appear and be treated as this number 3338366400 ?

The actual formula does a replace to get rid of dashes and a trim to get rid of spaces or hidden characters, but the issue exists even if I hard code the string into the formula column.

int() returns 2147483647 ( which is a cool number and all, but it's not the one I need ) and double() returns 3.3383664E9 which looks close, but the formatting options are either 1) no formatting or 2) time/date based which ... don't change the appearance at all

Ticket logged, but it's a sev 3 so Community has a real chance to win this race! 😉

Re: '003338366400' converts to 2147483647

JoeM — Wed, 17 Aug 2022 20:37:49 GMT

@RADSr - I got this. Did you try long()?

Re: '003338366400' converts to 2147483647

RADSr — Wed, 17 Aug 2022 21:04:28 GMT

Bingo! ( and Community beat support 😉 )

Re: '003338366400' converts to 2147483647

JoeM — Wed, 17 Aug 2022 21:29:36 GMT

The number 2147483647 truly is special. I believe -2147483647 to 2147483647 can be returned with int().