This content has been marked as final. Show 5 replies
Try this calculated field:
IF [program]="a" THEN [client id] END
If I'm understanding what you are trying to do correctly. All you need to do is drag that new calculated field to filters and exclude the Nulls.