want to know at each point Each WorkOrder Which point doesn't pass Spce?

[Sxbbb]

 want like this

Over spec each point is from not between min and max values.

By taking the number of each "SampleNo", each "WorKOrder" that is not between the min and max values

 Data Now

Example 1 work order

want to know at each point Each WorkOrder Which point doesn't pass Spce = that is not between the min and max values

[Sxbbb]

 want like this

Over spec each point is from not between min and max values.

By taking the number of each "SampleNo", each "WorKOrder" that is not between the min and max values

 Data Now

Example 1 work order

want to know at each point Each WorkOrder Which point doesn't pass Spce = that is not between the min and max values

[edwin]

try this:

load *, if(Value>=Min and Value<=Max,1,0) as Flag inline [
WO, Sample, Point, Value, Max, Min
WO1,1,1,32,30,22
WO1,1,2,31,30,22
WO1,1,3,30,30,22
WO1,1,4,25,30,22
WO1,1,5,24,30,22
WO1,2,1,33,30,22
WO1,2,2,32,30,22
WO1,2,3,31,30,22
WO1,2,4,26,30,22
WO1,2,5,23,30,22
WO1,3,1,33,30,22
WO1,3,2,32,30,22
WO1,3,3,27,30,22
WO1,3,4,26,30,22
WO1,3,5,33,30,22
];

this counts distint Sample no:

Count(distinct {<Flag={0}>}Sample)

you can also use

Count({<Flag={0}>}Sample)

if you dont count distincts