843508_en-US

liliconcom

Add final result column for different test conditions.

I did asked similar question earlier but that, that solution doesn't work when I have different number of test station for a same run. if run 1 has 2 tests and run 2 has 3 tests than this solution doesn't work.

 

If( Col Max( Col Sum( :Bin == "Pass", :SN, :Run ), :SN ) == Col Number( 1, :SN, :Run ),
"Pass",
:Bin[Col Min( If( :Bin != "Pass", Row(), . ), :SN )]
)

 

https://community.jmp.com/t5/Discussions/Add-result-column-based-on-diffent-binning-result/m-p/800448

 

How can I generate highlighted final test column using formula? 

 

Basic Data Analysis and ModelingRe: Add final result column for different test conditions.

Just add :Run to the fail side of the If clause

If( Col Max( Col Sum( :Bin == "Pass", :SN, :Run ), :SN ) == Col Number( 1, :SN, :Run ),
	"Pass",
	:Bin[Col Min( If( :Bin != "Pass", Row(), . ), :SN, :Run )]
)