Data type for more than 2 decimal places

l237598
Giga Contributor

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!

7 REPLIES 7

anavarro
Tera Contributor

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.

hunter_phillips
Tera Contributor

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.


https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/reference-pages/r...

This was driving me crazy  , thank you @hunter.phillips