Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
There is a column in my dataset Mon [ Storage type - String , Meaning - Decimal]
Im trying to add a filter on it. Which is Mon >0. It should give me all value except 0
As there are some date values in it. So its not taking date value from it. For this filter Mon>0 its taking all the values except 0, negative and Date values.
If you are looking for 'give me all value except 0', then the filter 'Mon >0' is not correct. This filter out all the values below 0, as you have mentioned. Based on your requirements, you are looking for something like 'Mon !=0'
You can do this visually in a Prepare recipe using the 'Filter rows/cells on value' processor: