Filter Date and Int value

Shashi

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

Miguel Angel

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:

Shashi

Want all the values which are grater than zero.