Remove row from Straight Table if one expression equals 0

[#1]

Hi,

I have a straight table that has multiple expressions included (about 6) and on each one I have the suppress 0 option enabled. What I've found though with this is that the row will only be removed if each of the expressions equals 0. Is there a way to remove the row if any one of the expressions equals 0 (or null if that's easier)?

Thanks

[senpradip007]

In your expression you can use Sum([Your Field])>0 in conditional expression enabling situation.

[Anonymous · Accepted solution]

For the other 5 expressions you could adjust them, by adding a suitable bit from the 6th expression that make it become zero, so that they also evaluate to 0.

You could instead do similarly for a Calculated Dimension, but I would not personally do that for performance reasons.

[anbu1984]

Check this

[#5]

I've added in a bit to the expression calculation that checks the value in question, and make it 0 when the other one is, and it works perfectly. Thank you very much for your help.