If any WorkOrder has 'NOT PASS', show the WorkOrder that is both 'PASS' and 'NOT PASS'.

[Sxbbb]

I haev field : WorkOrder , TYPE

I want to display 'WorkOrder' that has'TYPE '=  NOT PASS. 

If any WorkOrder has 'NOT PASS', show the WorkOrder that is both 'PASS' and 'NOT PASS'.

EX  WorkOrder ='A0204574-01-102'  that are both 'PASS' and 'NOT PASS' must show all ='A0204574-01-102'  details.

[justISO]

Hi, as one dummy workaround would be something like this:

=if(index(aggr(concat(distinct FA_Pass), WorkOrderNo), 'NOT')>0, WorkOrderNo)

and exclude (not show) null values.

[Sxbbb]

Thank you very much.

[Sxbbb]

I want to display FA_Pass = 'NOT PASS'  QTYPCS has only the largest value. 

EX  NOT PASS show at FA Code Reject = TC18