Spec Limit and Pass/Fail Column

[#1]

Hi,

I would like to ask if I set a particular column with spec limit(eg. low:100 and max:1000), from this limit set how can I create a corresponding column say Pass/Fail column to label those data within limit as Pass and out of spec as Fail.

Thank you.

[#2 · Accepted solution]

I guess I found the answer from another discussion :) Thanks!
By setting the Formula(in column properties, and use conditional IF function works fine.

If( 100 <= :MAX_MIN Test <= 1000,
"Pass",
"Fail"
)

[#3]

Hi,

Do you have an idea for general purposes- for example: I have 50 columns (all with spec limits property) 

How can I create this fail pass column if the sample (row) fails in one of the parameters?

By the way- I saw solutions to do it in JSL (I'm not so strong in JSL), but I want the functionality that the data will updated simultaneously, same as formula column   

Thanks for help!

[#4]

Hi,
If you're still looking for a scripting-free solution, YieldOptiX supports this out of the box — creating a pass/fail column based on multiple spec-limited columns.

Tutorial at 10:30:
https://www.youtube.com/watch?v=Nx5jWKAl7Z0&t=189s
It's built on JMP and designed for test data workflows.

Hope that helps!