Filter Tool - Query

[sunils]

Hi Everyone, I'm losing my mind and not able to catch what i'm doing wrong. 

I have this filter written and expecting only row 2 and 5 to be filtered but rest to carry on. In my workflow all 5 rows are filtered even though row 1/3/4 has data. Any help what i'm doing wrong?

[ACQ Cost] != 0 and
[Contract Cost] != 0 and
[Rebate Basis Price] != 0 and
[Contract Sell] != 0 and
[Invoice Price pre COGS] != 0

Rebate Basis Price	Invoice Price pre COGS	Contract Cost	Contract Sell	ACQ Cost
25	25	0	0	0
0	0	0	0	0
50	50	0	0	0
50	50	0	0	0
0	0	0	0	0

[fmvizcaino · Accepted solution]

Hi @sunils ,

It is common to confuse everything when dealing with negatives in logic expressions.  

By De Morgan's theorem, a two-input NAND gate's logic may be expressed as AB=A+B, making a NAND gate equivalent to inverters followed by an OR gate.

https://en.wikipedia.org/wiki/NAND_gate

[ACQ Cost] != 0 or
[Contract Cost] != 0 or
[Rebate Basis Price] != 0 or
[Contract Sell] != 0 or
[Invoice Price pre COGS] != 0

Best,

Fernando Vizcaino

[sunils]

Thanks a lot, that makes sense. I was not able to figure out what's going on.