Solved: In a column set to type Decimal, with 2 decim - Page 2

fdmsaraiva · 12-09-2018 04:00 PM

In a column set to type Decimal, with 2 decimal places, a formula that boils down to CONTAINS(2018.52,2018.5) is evaluating to TRUE.

Expected behaviour would be FALSE, as 2018.52 and 2018.5 are two different decimal numbers.

Workaround or fix?

Cheers!

Steven_Coile

IN() is your best choice to find whether a value is occurs within a list. Unfortunately, your options for checking whether a particular substring occurs within another string are limited.

View solution in original post