Add final result column for different test conditions.

ConfidenceOwl94 — Fri, 21 Feb 2025 20:45:45 GMT

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/800448

How can I generate highlighted final test column using formula?

Re: Add final result column for different test conditions.

txnelson — Sat, 22 Feb 2025 01:12:48 GMT

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

topic Add final result column for different test conditions. in Discussions

Add final result column for different test conditions.

Re: Add final result column for different test conditions.