Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Spec Limit and Pass/Fail Column

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 16, 2017 8:11 PM
(1480 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.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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"

)

By setting the Formula(in column properties, and use conditional IF function works fine.

If( 100 <= :MAX_MIN Test <= 1000,

"Pass",

"Fail"

)

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

By setting the Formula(in column properties, and use conditional IF function works fine.

If( 100 <= :MAX_MIN Test <= 1000,

"Pass",

"Fail"

)