Thank you Tanay!
There seems to be no logic in it but it’s exactly what worked for me – decimals stayed at 2 until I gradually increased max lenght :).

Use
Max length: “24” – without quotes (18 + 6)
Attributes: “scale=6” – without quotes

Works for me, tried on multiple fields.

Thanks for responding. There is a type called ‘Floating Point Number’. I have not used this data type before. I had created a new field with this data type, but I do not understand how to restrict the decimal places in it. Can you tell me how to restrict the points after decimal in these type of fields?

Regards,
Jayee

I think you’re doing it right, but ServiceNow has been changing how this works so much that it’s hard to know what should or shouldn’t work. You could try a floating point decimal field and see if that works better. Otherwise you’ll just need to talk to ServiceNow support.

I am facing an issue with decimal places. I have created 3 field in decimal. When I created them first of all it was taking more than 2 points after decimal. When I wanted to adjust it to 3 decimal places, I had given a Max Length of 18 and a scale of 3 in Attribute place, but I see it is taking upto 12 decimal places.

Previously also I had created decimal field, upto 5 decimal place. At that point of time I had given a Max Length of 20 and a scale of 5. It then worked perfectly.

Can you tell me the reason why is it not working, or am I doing something wrong?

Regards,
Jayee

You’ll probably need to discuss with ServiceNow if none of the solutions here work. From what I understand, they’ve designed it specifically this way. Not much you can do about it as far as I’m aware.

Thanks,
Bhushan