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 |
Solved! Go to 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
Thanks a lot, that makes sense. I was not able to figure out what's going on.