Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
Mon
129
325
43
0
3235
-11
0
0
47
-236
-436
28-04-2022 00:21
29-04-2022 00:21
30-04-2022 00:21
Hi,
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:
Want all the values which are grater than zero.