1 of 1 people found this helpful
You can try below logic:
1. Completed Machine? =
IF STARTSWITH([FA DESC],"PDI") THEN TRUE ELSE FALSE END
2. Quality Gate Defects ?
IF ISNULL([Disposition]) AND [CA_ID] <> '0_DEFECTS' AND NOT STARTSWITH([EVENT DESC],"0") AND [FA ID]='300' and [Q/V]='Q' THEN TRUE ELSE FALSE END
[Completed Machine?]= TRUE AND [Quality Gate Defects ? ] = TRUE
Drag "Flag" to filter and select "TRUE".
If this helps you to solve your query, please mark it as CORRECT/HELPFUL
else please share mock -up data.