Trouble comparing database decimal value against numbers from csv

Support
1

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
image1228×566 30.9 KB

image
image

2

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

image
image1409×559 17.7 KB

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

3

Thanks,

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

4

The bug has been fixed in v5.5.

1 Like