Precision loss?

Get Help
1

I have a table with a numeric field, typically with 3 decimal places.

I am querying the table where amount = 0.222, and I get the results, but the amount field is showing 0.22 and not 0.222, losing the final precision.

I tried changing the field type to currency, price, and different options, and this didn't help. I never adjust the field types, so this has never been a problem in the past that I have noticed. I am not sure if this is the result of a new update, bug, or some setting. I also rescanned db, rescanned field values.

2

Most probably Metabase is rounding it, have you changed the minimal amount of decimal places shown?

3

yeah, I ended up having to change the display and specifically set the decimal places, but I didn't have to in the past.