topic Re: Spec Limit and Pass/Fail Column in Discussions

Spec Limit and Pass/Fail Column

adam — Tue, 17 Oct 2017 03:21:01 GMT

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.

Re: Spec Limit and Pass/Fail Column

adam — Tue, 17 Oct 2017 04:11:16 GMT

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"
)

Re: Spec Limit and Pass/Fail Column

BlockLevelsFrog — Wed, 12 Feb 2025 10:01:35 GMT

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!

Re: Spec Limit and Pass/Fail Column

PercentileSeal4 — Tue, 15 Apr 2025 12:32:15 GMT

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!