- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 12:18 PM
Hi,
I have a decimal type field on my form and I want to set a default value: 1.00, but when I open a new record on my table, that field will have just a single "1" as a value. I set the scale to 2 and the max length to 20 and I also put 1.00 to the default value field.
I tried this method: https://community.servicenow.com/community?id=community_article&sys_id=4ab304e51b0e48d0ada243f6fe4bcb12
But it didn't work for me.
Thank you,
Csaba
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 01:08 PM
Hello
If the number has .00 after, it's considered a whole number and will not show the .00 in the decimal field, regardless for the scale value set.
If you tried .01, for example, you'll see it.
There is no official workaround for that.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 12:33 PM
Hi,
Can you try something else other than .00
Mark Correct or Helpful if it helps.
***Mark Correct or Helpful if it helps.***
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 01:07 PM
Actually, it needs to be 1.00

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 01:14 PM
I have tested it you cannot do it 1.00 it truncates the 00 after dot and 0 if you try 2.90 > 2.9
If you always want to show .00 there could be a possibility you can use onLoad client script and concatenate but its not the good thing to do at all
***Mark Correct or Helpful if it helps.***

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 01:30 PM
I am happy you found your answer but didn't I answered you first ??
***Mark Correct or Helpful if it helps.***