We have a requirement to save floating numbers and retain the amount of trailing zero’s as input by the user up to 6 decimal places, but the decimal128 field is truncating the trailing zeros. ie if the user enters 2.000000 it is stored as 2. Is there a way to retain the trailing zeros in the database on a decimal128 field?
You can format a string to preserve trailing zeroes to the right of the decimal point, but the Decimal128 format does not save the number of trailing zeroes that were used to create the number.
If you really need to know what the user input, I believe you will have to save the string value of the input along with the Decimal128 value.