cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

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.

 

<JSL>

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/80044...

 

How can I generate highlighted final test column using formula? 

ConfidenceOwl94_0-1740170580711.png

 

1 REPLY 1
txnelson
Super User

Re: 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 )]
)

txnelson_0-1740186763188.png

 

Jim

Recommended Articles