Straight table - hide rows where expression(s) equal value

matthewp — Tue, 11 Oct 2016 08:57:56 GMT

I have a straight table and it has 13 dimensions and 4 expressions

The expressions are

=ANET-BNET

=AVAT-BVAT

=AGROSS-BGROSS

I want to hide all rows where ANET-BNET = 0 OR AVAT-BVAT = 0 OR AGROSS-BGROSS = 0

Re: Straight table - hide rows where expression(s) equal value

sunny_talwar — Tue, 11 Oct 2016 10:28:47 GMT

So try this:

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, ANET-BNET)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, AVAT-BVAT)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, AGROSS-BGROSS)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, 4th Expression)

You mentioned 4 expressions, not sure if you have 3 or 4, but if you have the 4th, then add the same condition to the 4th expression also