Decimal Type Field Value is Auto updating

[Ratan B]

Hi Community,

Issue is whenever am putting decimal point value in field(Type : Decimal), the value is auto Rounding off and updating. 
Before Save : 

After Save : 

Because of this other calculations are giving different values.

[Beata I_owiecka · Accepted solution]

Hi @Ratan B ,

You can adjust the decimal places by right clicking in 'Logged hours' label and then 'Personalize -> Dictionary'.

more info: https://servicenowguru.com/system-definition/controlling-decimal-field-places/

[Tushar Walveka2]

Hi @Ratan B ,

It's normal for the database to behave this way.

To ensure your changes to the number of decimal places (scale) are reflected correctly, you need to adjust the maximum length of the field at the same time. Modifying only the scale won't update the database, and the original settings will remain in effect.

Here's how to make the changes:

1. Access the advanced view: Open the dictionary of decimal field in your table.
2. Set the scale: In the attributes field, add "scale=5" (or your desired number of decimal places).
3. Adjust the maximum length: Change the "Max length" value to something different than the current setting (usually 20).
4. Save your changes

By following these steps, you'll ensure the database accurately stores values with the updated number of decimal places.

• When a new column of type decimal is created without initially setting the scale, it defaults to 2.
• Subsequently altering the scale value requires adjusting the max length value twice to ensure that the database reflects the updated scale value.

Regards,
Tushar Walvekar