Double filter of aged items

[esabay]

Hi all newbie question sorry: how do I do this filter? The result would only include the item if both Age 1 and Age 2 is greater than or equal to 5. Thank you

Item	Age 1	Age 2
Rabbit	100	5
Horse	5	0
Dog	6	0
Cat	8	3
Cow	24	4
Man	25	6
Toys	57	6

[alexnajm]

[Age 1] >= 5 AND [Age 2] >= 5

[esabay]

Hi thank you for your reply. I am having this error when running the workflow. Please help 

[alexnajm · Accepted solution]

My assumption would be that your age columns are not being stored as numbers. Use a Select tool before hand to change those columns into Int 

You can also force them to be numbers in the filter by doing 

ToNumber([Age 1]) >= 5 AND ToNumber([Age 2]) >= 5

[esabay]

Thank you this worked like a charm. Apologies again for the newbie question but on my age 2 items on my live data I have null values on some of them. How do I filter to include data when both Age 1 and Age 2 are greater than 5 and include data when Age 2 is null and Age 1 is greater than 5. Thank you for the help so far. Appreciate it

[alexnajm · Accepted solution]

You can add any amount of conditions as long as you link them with OR or AND operators, dependent on your filter. In this case, it sounds like you should add OR [Age 2] = null()

[esabay]

I cant thank you enough @alexnajm . It worked. Appreciate the patience have a great day

[alexnajm · Accepted solution]

Happy to help! Thanks for marking one of my responses as a solution too - if other parts were also helpful, make sure to mark those as well 😊 otherwise have a great day!

[SriNarendra · Accepted solution]

Hi have to use filter tool and apply this condition  [Age1]>=5 and [Age2]>=5