Filters are not working when using multiple "AND" conditions

[Himanshu4]

Hi,

I am unable to filter the data using multiple "AND" conditions in workfront fusion, Its working with only one "AND" condition and not with 2 or 3 conditions. 

Any one has any idea if there is a way to do that? or Is it not possible to use two "AND" conditions in a fusion scenario?  Attaching a screenshot for reference

Any suggestion or help would be highly appreciated. TIA

[Sven-iX]

The filter will only pass a bundle if a bundle meets all the AND conditions. In your case you can see it does not meet 2 of the conditions so it doesn't pass. 

Can you spell out in English the expected logic?  like "If XXXX equals YYYY and ZZZ doesn't contain bbb.... etc. 

And provide the case that you think should go through but is not.

I don't understand the 1 part of the filter:  5 days before = 5 days before ?

[Himanshu4]

@Sven-iX  Thank for looking into it. The logic I am trying to create is if Event date is less than 5 days and Event Name is equal to Canada and Japan only then it should pass through it.

[Sven-iX · Accepted solution]

Ah - then you need to change it to 

• if Event date is less than 5 days AND Event Name is equal to Canada 
  OR
• if Event date is less than 5 days AND Event Name is equal to Japan

[Himanshu4]

@Sven-iX It worked. Thank you so much for your help.