topic Re: Exclude certain rows in table in App Development

Exclude certain rows in table

ToinkToinkTigger — Wed, 19 Oct 2022 08:25:03 GMT

Hello everyone,

I have a question regarding the following. I would like to exclude all table rows that have the value ''% of Completion=100%''. So show all associated colums in the table with % completion <100.

I cant get this to work in the table expressions. How to achieve this?

Thanks in advance

Example table below:

Re: Exclude certain rows in table

Andrew_Delaney — Wed, 26 Oct 2022 13:30:55 GMT

Hi ToinkToinkTigger, I think this old post on show/hide rows based on values might have what you need.

Re: Exclude certain rows in table

Mark_Little — Thu, 27 Oct 2022 06:39:10 GMT

HI @ToinkToinkTigger

As @Andrew_Delaney has suggested you could use an if statement or you can actually used your Set analysis in the expression like here