Add multiple filters to one filter

[dberroth]

Hello - I know there have been multiple posts regarding this question but I am not having any luck. I am trying to do all these filters in one job. The one filter that is blank is CRM FRISK is null. Everything I'm trying is not working. any direction would be much appreciated.

[jrgo]

@dberroth 

I could be mistaken on what exactly it is you're asking for help on, but if the question is if you can consolidate the expression used in each filter into one, the expression below could be used

![Total AR Balance]
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")

For the last 4 Filters, I use a NOT operator with the IN clause.

If I did misunderstand the question, can you clarify?

Jimmy
Teknion Data Solutions 

[DiganP]

@dberroth Would you be able to attach a sample dataset? It would help us understand the workflow better.

[dberroth]

@jrgo you have the right idea of what I'm trying to do. I'm basically trying to clean up this flow so it looks more presentable and clean. The statement you gave me makes sense, but now I'm not getting any data. All records are coming out as false. Any ideas? Your formula makes sense to me. 

[dberroth]

The formula I'm using now is below. I only need the total AR balance greater than 50000. I took what was given earlier in this post and added the >50000. Doesn't make sense to me why this wouldn't work and only come back with falses after these same filters shown in my original post works.

![Total AR Balance] > 50000
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")

[jrgo]

@dberroth 

Remove the ! From the first field. I was curious to the reasoning for it in your original example, but based off your change it’s not logical in that context.

[Total AR Balance] > 50000
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")

[dberroth]

So this is what I'm using now...

[Total AR Balance] > 50000
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")

I am now getting this error...

The formula makes sense and reads correctly, I'm kind of at a loss here

[jrgo]

@dberroth 

Apologies... I wrote the last condition incorrectly putting the NOT in the wrong place.

Should be

[Total AR Balance] > 50000
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND [Risk Category] NOT IN("MISFRT","YARD","FLIP","CARREP")

[dberroth]

No need to apologize! I'm just a newbie trying to learn! My last question 🙂 Is there a way to tie the trues and falses into one worksheet on different sheets? So I want the true's on one sheet and the falses on another in one document?

[dberroth]

I added a block to this, but now it seems the filter stopped working. 400 trues and 400 falses are coming out on both sheets now. Is this a formatting issue?