Data type for more than 2 decimal places
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2012 09:45 AM
I'm uncertain what Type to use for a new column that will hold values with 4 decimal places.
The Wiki "Introduction to Fields" says type of decimal has only 2 decimal places, and type of integer has no decimal places.
I see types of numeric and float in the type choice list, but don't know which, if either, of these would be appropriate for storing values with 4 decimal places.
When I try those types, neither of them gives me a place to define the number of decimal places for the column.
Can anyone provide guidance for me?
Thanks!
- 12,325 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2019 04:41 AM
Anyone found a solution to this? I've tried adding ",scale=5" to the Attributes field since I could not find it on the Attributes related list. I still get a 1.54 value even though the variable I have used and logged to set the field says 1.53800.
If you're still struggling with this, please hit the upvote button so this question has more visibility.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2020 05:34 AM
If you need 7 digits or less, it looks like you can use the Floating Point Number field type
Decimal - Number with up to two digits after the decimal points (for example, 12.34).
Floating Point Number - Number with up to seven digits after the decimal point.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2020 06:17 AM
This was driving me crazy , thank you