Number of decimal places always rounds to 2 even when 'scale' is attribute is set - Known Error

Number of decimal places always rounds to 2 even when 'scale' is attribute is set Description When setting the 'scale' attribute on a Decimal type field to anything greater than 2 places, the values saved in the field still get truncated and round to 2 decimal places.

Steps to Reproduce

Create a Decimal type field on the incident table Set the 'Scale' attribute to 10 on the dictionary record Create a new incident and add the value 4.123456789 Save the record You will notice that that the value was truncated and rounded to 4.12 Workaround This is expected behaviour. The max length value needs to be changed at the same time as the scale value in order to have the correct values at the database level. If you change the scale alone then the DB does not reflect the change, which means the default values are still used.

Open the Advanced view of the dictionary entry for the Decimal field of your table Add "scale=5" (or another number) to the attributes field Click on "Save" Modify the field value of "Max length" to something different than it currently is (the default is 20) Click on "Save"

If you created a new column of type decimal and don’t set the scale initially, it will default to 2. If you then change the scale value to another number then you need to change the max length value twice in order to have the DB reflect the scale value.