how to retains decimal field 2 places after record submits
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2017 10:31 PM
I am stuck at a decimal field cosmetic where the 2 places need to present always, for example, if users enter 123.00, the .00 need to stay when the record is submitted.
In ServiceNow, this is not a difficult thing to do if the field is set to Currency or Price, however, due to the limitation of list editing. The users are not able to edit in List view; therefore I had to work this around by changing it to a decimal field which allows users to edit, which is great!!
However, the Decimal field does not retain the 2 places after submitting when a whole number is entered, e.g 123.00
After submitting the record, the 2 places are gone
Is any way to always retain the 2 places all the time.
Thanks.
- Labels:
-
User Interface (UI)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2017 10:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2017 11:03 PM
Hey Priyanka
Sorry I must have forgotten what i mentioned or lost the URL. Would you mind giving the url?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2017 11:20 PM
Hi George,
I have seen the screenshot shown in this query, can you tell me which url you are looking for?
Thanks,
Priyanka R
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2017 11:26 PM
Hi George,
Below mentioned links may be useful for your query:
How to round decimal field value to two decimals in business rule
https://www.servicenowguru.com/system-definition/controlling-decimal-field-places/
Hope this helps.Mark the answer as correct/helpful based on impact.
Regards,
Shloke
Regards,
Shloke