Can't set a default decimal value 1.00

Csaba B_rsics
Tera Contributor

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

1 ACCEPTED SOLUTION

Allen Andreas
Administrator
Administrator

Hello @Csaba Bársics 

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!

View solution in original post

6 REPLIES 6

Yousaf
Giga Sage

Hi,

Can you try something else other than .00



Mark Correct or Helpful if it helps.


***Mark Correct or Helpful if it helps.***

Actually, it needs to be 1.00

 

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.***

@Csaba Bársics 

I am happy you found your answer but didn't I answered you first ?? 


***Mark Correct or Helpful if it helps.***