I figured out the code and got the wrong value.

[Sxbbb]

I want to create a table like this

Where 'With in spec' comes from Value>=Min and Value <=Max.

Example 1 work order

I can do it but then the Data  is wrong.

used code of  'With in spec'.

(Count(Aggr(if(Value>=Min and Value <= Max,1,0),Line,WorkOrder,SampleNo,Point))).

[hic]

I assume that a WorkOrder can have many Samples, and a Sample can have many Points.
And you want ALL OF THEM to be within specs in order for the WorkOrder to be WithinSpec?

Try

Count(distinct {<WorkOrder={"=Max(Value)<=Max and Min(Value)>=Min"}>} WorkOrder)

or

Count(distinct Aggr(if(Value>=Min and Value <= Max,WorkOrder),Line,WorkOrder,SampleNo,Point))

[Sxbbb]

I try  Count(distinct {<WorkOrder={"=Max(Value)<=Max and Min(Value)>=Min"}>} WorkOrder) 

This is Result 

 And I Want  Out of Spce  

 I Try I try  Count(distinct {<WorkOrder={"=Max(Value)>=Max and Min(Value)<=Min"}>} WorkOrder) 

Result 

But Total With in spec Sum Total out of Spec not equal Total WorkOrder 

1618+964 not equal  8996  ( Total WorkOrder )

should be combined to equal Total WorkOrder