If Filter Help

[wonka1234]

I have this dataset - 

One Conclusion	Two Conclusion	One Status	Two Status
Effective	Effective	Ready	Ready
Effective		Ready
Effective		Ready
Ineffective		Ready
Effective		Ready
Ineffective		Ready
Effective		Ready

In the true part of my filter its only returning the First Record.

My filter:

[One Status] = "Ready"
AND [ One Conclusion] = "Effective" OR [ One Conclusion] = "Ineffective"

Or [Two Status] = "Ready"

AND [ Two Conclusion] = "Effective" OR [ Two Conclusion] = "Ineffective"

How can I adjust this filer to account for all 7? 

The logic should be if  One Status is ready and Conclusion is either effective or inffective then TRUE.. Same for Two status.

Any help would be appreciated.

[alexnajm]

It looks like you some some Null values you have to account for!

[JimmyV · Accepted solution]

wonka123,

I think what you're ultimately looking for has to due with adding opening and closing parenthesis to your logic to make it work when you clear update your null values. So something like below might be a start of what you're trying to do with your expression.

([One Status] = "Ready"
AND ([One Conclusion] = "Effective" OR [One Conclusion] = "Ineffective"))
OR
([[wo Status] = "Ready"
AND ([Two Conclusion] = "Effective" OR [Two Conclusion] = "Ineffective")) 

[flying008 · Accepted solution]

Hi, @wonka1234 

Your formula must be account for the null of [One Conclusion] and [Two Conclusion].

[One Status] = "Ready" &&
[One Conclusion] in ('Effective','Ineffective') 
||
[Two Status] = "Ready" &&
[Two Conclusion] in ('Effective','Ineffective') 

[ArnaldoSandoval · Accepted solution]

Hi @wonka1234 

As suggested by @JimmyV your condition is missing parenthesis, I attached a workflow with your formula and JimmyV's

( [One Status] = "Ready" AND ([One Conclusion] = "Effective" OR [One Conclusion] = "Ineffective") )
OR
( [Two Status] = "Ready" AND ([Two Conclusion] = "Effective" OR [Two Conclusion] = "Ineffective") )

Hope this helps,

Arnaldo