Hi, I need help with filter on my report.
I would like all ID in Ed=Y and IP = N. and I also want if IP = Y in any line in the same ID, this ID will be excluded also
For example,
ID =18056 had 2 line, I do the filter on ED = 'Y' and IP = 'N', it still show ID = 18056
Set ID LA_NM FST_NM DOB ED IP Stay
E 18001 CHA ANDRESS Jun 2, 2017 Y N
E 18056 CHA ANDRESS Jun 2, 2017 N Y
I 18056 CHA ANDRESS Jun 2, 2017 Y N
E 18041 CHA ANDRESS Jun 2, 2017 Y N
E 18041 CHA ANDRESS Jun 2, 2017 Y N
Thank you!
Just create a 2 filters :
A) [ED]='Y' AND [IP] ='N'
B) [IP] <>'Y'
If you want to use only one filter A) or B) should work
this work!