Multiple selection in custom filters

Naveenhb

Hi,

I have a data set  having 20,000 records with 21 country's names. I need to apply multiple filters to arrive at value for each country. There are 5 filters applied for each country

common filters applied to each country

1. Country - country name filtered

2. VAT Code - vat code filters

Succeeding filters applied 

3.Address - selected country address

4. Code - some condition

5, Total tax amount - Amount 

If above 5 filters applied  I should arrive a value "matched" otherwise " no match". I have attached sample workflow. I need to have single formula containing all filters or how to reduce these multiple filters with less processing time. Please guide.

filters issue..PNG

dpakapd

Have you tried using the 'AND'/'OR' logic when using the filters? You can use that to group the fields together. For example taking a quick look at your screenshot, you can combine the top row of filters as:

'VAT_CODE = S2' AND Contains([Address], "United Kingdom") AND (!Contains("Indemnified Employee")) AND ([Total_Tax]-[Amount]

>0).

I made a small example below: