Multi Column filter

elclark

Hello - I'm trying to filter my file based on two columns, Days to Next Purchase and Days since Prior Purchase. I want my results to include any transaction that has a number between -3 and 3 in the Days to Next Purchase column or the Days since Prior Purchase column. I've tried various combinations of using OR/AND in my statement but I still end up with results in the false output that should be true. Is there a way to do this with a filter?

[Days to Next Purchase]<=3 AND [Days to Next Purchase]>=-3 

AND

[Days since Prior Purchase]<=3 AND [Days since Prior Purchase]>=-3

Here is an example of how I would expect them to be filtered.

Transaction #	Days to Next Purchase	Days since Prior Purchase	Filter Results
1	-5	-5	FALSE
2	-4	-1	TRUE
3	-3	21	TRUE
4	-2	22	TRUE
5	-1	0	TRUE
6	0	1	TRUE
7	1	5	TRUE
8	2	10	TRUE
9	3	45	TRUE
10	4	55	FALSE
11	5	3	TRUE

mmish

Using your logic and changing the AND to an OR statement in the Filter is working as you specify.  Are there data points you are using that are not working?

[Days to Next Purchase]<=3 AND [Days to Next Purchase]>=-3

OR

[Days since Prior Purchase]<=3 AND [Days since Prior Purchase]>=-3

Multi Column Filter.yxmd