cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SohailKhan

Increase limits of decimal column type in CDS

Submitted by on ‎12-22-2020 02:59 PM

The decimal field type only lets you use values between -100 million and 100 million.

 

This is way too small for the data we want to import - any financial reporting solution will find this limit difficult to work work.

 

Please increase the size of this column type to be in the 10s or even 100 billions range.

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
engferno
Regular Visitor
‎01-04-2021 01:07 PM

I think also here is not only to increase the amount that handled, but to what level of precision. Storing $903,392,340.39435834838 is not supported. Currency truncates after 4 decimals, and while that works for some cases, those decimals are important in aggregations at financial institutions where millions of decimal transactions are at stake.

I shouldn't have to resort to storing as text or splitting amongst 2 separate columns to store the integer and decimal portions...