Suppressing a row based on the output of a single expression when there are multiple expressions
Hi all. So I have a table chart with a number of expressions. Some of these expressions are binary flags, 1 or 0, depending on a condition. I was using these expressions to remove rows where the expressions equal 0 using the Supress Zero Values option. Some expressions reference each other though, so I check whether or not another expression came back 1 before calculating.
Is there a way to force the row to disappear based on the value of just a single expression, even if the other expressions have non-zero values?
My problem is if some of the conditions come back 1, but a later one comes back 0, I need the row to disappear. Since they reference each other in a series of sequential checks, I can't go back and use a later expression as a condition for an earlier one.
I hope this isn't too confusing. Thanks for the help!