Exclude row if every expression has value = 0

[Daniel1908]

Hello together, 

I created a table with different expressions, everthing works fine, but I want to delete a row if every value is 0. 

Kind Regards,
Daniel

[rubenmarin1 · Accepted solution]

Hi, in table properties (right menu) -> add-on  section -> data management, you have an option to include zro values, uncheck that box to hide rows with all expressions set to zero (if one expression is different to zero it will keep showing).

[Daniel1908]

Perfect, thanks for your help.

Kind Regards
Daniel

[cgT]

Hi there,

I've tried this and am still getting rows of data that all total 0. Is there a reason as to why this might not be working?

Many thanks,

[Bhavika15_]

Yes this works but all the 0 value now is blank, how can this be solved as I want other  values to remain 0 not blank

[rubenmarin1]

Hi, this is a thread from 2021, please open a new one  for your case (you can link this one for better context) and add more info about your table, depending of the number of columns and display there are different solutions.