Trouble comparing database decimal value against numbers from csv

I am not sure what exactly I am doing wrong. Can someone help me please.
Sometimes I have trouble comparing Database decimal value against numbers from csv.

numbers.zip (1.5 KB)

I am wondering why it is showing 780282.25000000000000000000 <> 780282.25

I am using Version 4.7.2.3. And cant upgrade to newer version that our IT dept. manages it…


image
image

You can try using the round(x,2) function before doing the matching.

Seems like a bug, though. We’ll investigate it.

Thanks,

I am doing that. Just thought to report it in any case.