Exclude certain rows in table

[ToinkToinkTigger]

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:

[Andrew_Delaney]

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

[Mark_Little]

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