Compare 2 data in 2 columns then mark it Pass or Fail then count all Pass or Fail based location and testcode
Hello,
I have 2 columns named Minutes_Diff which is a result of a calculation(Ex: 5, 15, 16, 37 and etc). The 2nd colum named Target_Min is an Inline Load containing 5,10,15,20,25 up to 90 in increment of 5.
I want to add Target_Min to the a multi-box calls Selection Criterias so the user can decide which Target_Min to use in the comparision to Minutes_Diff.
If Target_Min selected is 15 then all records with Minutes_Diff greater(>) than 15 mark as Fail. All records with Minutes_Diff less then or equal to (<=) 15 mark as Pass
Then count all Fail and Pass group by location and test code.
