"Does not contain" Filter

[Tsura Andreeva]

I have 3 reports for a specific Assignment Group,the first two reports bring back total number of tickets that use fitler Short Description contains "word A"  and Description contains "word B" or Project number "word C" the result brings back the correct numbers. - I evaluated the results between the two reports.

The idea is that the 3rd report should bring the rest of the results back with fitler as do not contain, what the first two reports filter in by using does not contain,  however my result set brings back all tickets.

I think I need help in using filter does not contain multiple times and the OR statement to get all of the tickets that do not contain A or B or C 

I have attached my filters: anu suggestion or help will be valuable

[SanjivMeher]

You need to use

Short Description DOESNOT CONTAIN word A 

AND

Short Description DOESNOT CONTAIN word B

AND

Short Description DOESNOT CONTAIN word C

[Tsura Andreeva]

If I do that I am only filtering out tickets that do not contains all 3 not one or the other.

[SanjivMeher]

So your report 1 will bring everything which contains Word A as short Description

That is 

It will have records with 

Word A

Word A + Word B

Word A + Word B + Word C

Report 2 is Description = B or Project is C

result

WordB

wordC

Word A + WordB

Word A + wordC

Word B + Word C

Word A+ Word B +word C

So what you want is record with doesnt contain any of the 3

Short Description DOESNOT CONTAIN word A 

AND

Description DOESNOT CONTAIN word B

AND

Project DOESNOT CONTAIN word C

[Tsura Andreeva]

that is correct I want all records that do not contain all 3 but also I want to exclude records that that might have only A or a records that might only have B or a records that might only have C

TOTAL incidents before any fitlers for that group is 5000
1st report contains word A gives back 400
2nd report contains word B or word C gives result back of 1400
so technically the 3rd report should be

TOTAL number of 5000-400-1400 = 3200 but with your logic I am only getting back
300 the total number of records that do not contain A and B and C at the same time

thats another 2900 records that are not filtered properly if I use your suggestion

 test it on your end let me know what you get