Pass and Fail Condition

[#1]

Hi Guys,

I have the following table and would like to know how shall I set the formula(or JSL) where in this case, based on ID and MAIN_RAD, I would like to check on the value of SUB_1 to SUB_3. The condition is if at least 2 of the SUB has a value of more than 20 then it will be considered as FAIL otherwise PASS.

For instance as you will notice, for M101X at MAIN_RAD 1, the SUB_3 is more than 20 but consider PASS as it did not fulfill the condition of at least 2 SUB more than 20 in spec limit.

Thank you.

ID	MAIN_RAD	SUB_1	SUB_2	SUB_3	RESULT
M101X	1	10	15	29	PASS
M101X	2	15	5	16	PASS
M102W	1	25	18	30	FAIL
M102W	2	8	14	11	PASS
M110A	1	32	12	15	PASS
M110A	2	51	45	30	FAIL

[#2 · Accepted solution]

Here is a formula that will do what you want

If( Sum( SUB_1 > 20, SUB_2 > 20, SUB_3 > 20 ) >= 2,
	"Fail",
	"Pass"
)

The Sum() function is documented in the Scripting Index

     Help==>Scripting Index==>Functions==>Sum

The handling of Boolean logic is covered in the Scripting Guide

     Help==>Books==>Scripting Guide

If you are going to to be using JSl, you need to take the time to read the Scripting Guide!

[#3]

Thanks Jim !