cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
adam
adam
Level IV

Spec Limit and Pass/Fail Column

Created: Oct 16, 2017 11:11 PM  |  Last Modified: Oct 16, 2017 8:21 PM (5263 views)

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.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
adam
adam
Level IV
Solution

Re: Spec Limit and Pass/Fail Column

Oct 17, 2017 12:11 AM (6124 views)  |  Posted in reply to message from adam 10-16-2017
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"
)

View solution in original post

1 REPLY 1
adam
adam
Level IV
Solution

Re: Spec Limit and Pass/Fail Column

Oct 17, 2017 12:11 AM (6125 views)  |  Posted in reply to message from adam 10-16-2017
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"
)