01-21-2013 04:52 PM
This seems like a silly question, but given that I have these numeric values...
... why can't I use this in order to extract all rows withere Differanse is higher than 0?
When I try that, it just extracts all rows. I've also tried Differanse > 0, with the same lack of result.
01-21-2013 05:14 PM
You probably have some floating point errors going on, where the number is actually 0.000001 but displaying as 0.00.
There are other options if you can't use the above method as well.
01-22-2013 02:25 AM
i see that the values in the column are aligned to the left, as you know character values are aligned to the left and numeric values are aligned to the right. So i believe the values of column Differanse are character. Try to convert them into numeric and then try what you have mentioned in the post above.
or else you can use Differanse^="0,00". Hope this helps you.
01-22-2013 02:46 PM
Looking at the column header and the image (from DIS) it is a numeric field with a format applied (which is probably aligning to the left)
01-22-2013 06:47 AM
Consider how this columns gets populated. Integers (including zero) should normally work properly with such conditions.
You may want to use the round() function to get control of your data.