Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
In your expression you can use Sum([Your Field])>0 in conditional expression enabling situation.
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.
Check this
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.