Skip to Content
avatar image
Former Member

How do I hide all lines if any line contains certain value?

capture.png

If any matching [Nomination Technical Key] has a [Document Indicator Key]= "P" & "T", exclude all [Nomination Technical Key] lines. How do I accomplish this?

capture.png (57.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 26, 2017 at 04:10 PM

    Show/Hide=if([Document Indicator Key]= "P") or ([Document Indicator Key]= "T") then "hide" else "show"

    Apply filter filter on Show/Hide and select show.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2017 at 01:22 AM

    Worked! Thank you!

    Add comment
    10|10000 characters needed characters exceeded