Conditional Pass/Fail based on limit

adam

Hi guys,

 

Similar to one of previous posts, I have the following problem as shown as below:

 

In this case, if any of the result is >=15 in at least two sub_rad then it is consider Fail otherwise will be regarded as a Pass(as shown in the Pass_Fail col). Currently I'm using Formula but only know how to do it in a single sub_rad. Kindly suggest how can I do it with a script or formula.

 

Thank you.

 

ID	test_id	test_type	main_rad	sub_rad	result	Pass_Fail
M101XS	566	31	2	0	15	Fail
M101XS	566	31	2	1	16	Fail
M101XS	566	31	2	2	11	Pass
M101XS	566	31	3	0	12	Pass
M101XS	566	31	3	1	13	Pass
M101XS	566	31	3	2	14	Pass
M101XW	568	33	2	0	12	Pass
M101XW	568	33	2	1	16	Pass
M101XW	568	33	2	2	12	Pass
M101XW	568	33	2	0	12	Pass
M101XW	568	33	3	1	18	Fail
M101XW	568	33	3	2	20	Fail

txnelson

This is a guess on what you want......not sure all of the conditions are properly being checked on

This is a formula.....not open JSL code

dt = Current Data Table();
holdID = :ID;
holdtest_id = :test_id;
holdmain_rad = :main_rad;
numGE15 = N Rows(
	dt << get rows where(
		holdID == :ID & holdtest_id == :test_id & holdmain_rad ==
		:main_rad & :result >= 15
	)
);
If( :result >= 15 & numGE15 >= 2,
	"Fail",
	"Pass"
);