Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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