I have a table called DB and with a column called Status.
The status values are typically:
‘In progress’,
‘Hide-not required’,
‘hide - completed’
I want to display all the rows where the Status column does not contain the word ‘hide’.
What code do I write in the 'Row filter condition;?
Many thanks
Solved! Go to Solution.
@Saleh
I believe you are trying to create a slice. You can use below expression for that purpose:
NOT(CONTAINS([Status],"Hide"))
@Saleh
I believe you are trying to create a slice. You can use below expression for that purpose:
NOT(CONTAINS([Status],"Hide"))
Yes perfect. Thanks
You’re welcome. @Saleh can you also mark my reply as the solution pls? Thnx.
Sorry, can I just ask,
Can I also add another statement to that so it that it should filter the rows further s that it only shows rows where the column [Priority] has the letter “U”.
Thanks
@Saleh
You can construct an AND expression:
AND(NOT(CONTAINS([Status],“Hide”)), CONTAINS([Priority],"U"))
OR
AND(NOT(CONTAINS([Status],“Hide”)), FIND("U",[Priority]) > 0)
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |