Decimal column value in detail view changes randomly

[Fos23M]

I have a detail view with a quick edit column which is a reference list of brands, and when I select a brand, the column "C02 Content" gets filled automatically using a LOOKUP() formula. Like this:

Now, the issue is that after a few seconds the "CO2 Content" value will change on its own, rounding up to 2.00:

That said, all the following calculations that use the value of "C02 Content", do not change, they still behave as if this column is value 2.60, and everything works perfectly, even though it is now showing 2.00.

I don't understand why this is happening, does anyone have any idea?

Thank you very much for your help.

[Steve]

First, please read the LOOKUP() help page in its entirety. Perhaps you're making a common mistake?

If that doesn't help, please post a screenshot of the entire expression you're using to produce the value.

[Swoopy]

This may help,

1. Ensure that all columns used in calculation are set to 2 decimal.

2.Use TEXT(...calculation...)