on 05-25-2017 2:46 PM
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Worked! Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.