Count no of entry in column to calculate yield.

[#1]

How can I Count no of fail and pass by Lot to calculate yield. I want to do this using formula. (Tabulate function is working just fine. But I like to know how to do that using formula)

[#2]

Select Lot as "Group By" variable (right click on this column, and you'll find this option after "new formula column"), and then right-click on "Result" column, "Group By" and then choose "Count".

[#3]

This will "count" the non-missing entries.

edit: "count?"
JMP can only count Number - not Strings.
... at least bast on the available options in the right-click-menu.

From JMP19 onwards, JMP can also count unique Strings:

But still: no 1-click-appraoch to count strings.

https://community.jmp.com/t5/Discussions/Collection-of-quot-funny-quot-Jmp-newbie-questions/m-p/9105... 

[#4]

You can use Tabulate:

Drag lot onto the vertical axis and Result onto the header. Then drag Row% onto the main drop zone.
In Column "Pass", you can read the yield in %.

Tabulate(
	Add Table(
		Column Table( Grouping Columns( :Result ), Add Aggregate Statistics( :Result ), Statistics( Row % ) ),
		Row Table( Grouping Columns( :Lot ), Add Aggregate Statistics( :Lot ) )
	)
);

[#5]

to calculate the yield via a column formula, you can use:

New Column( "yield_",
	Format( "Percent", 9, 2 ),
	Formula( Col Sum( :Result == "Pass", :Lot ) / Col Number( 1, :Lot ) )
)

[#6]

Hi @hogi,

It is possible but require some work on the datatable:

1. Recode Pass to value "0" and Fail to value "1"
2. Change column "Result" data type to Numeric and Modeling type to "Nominal"
3. Add a column property "Value Labels" to identify what the 0s and 1s mean (and display it in the datatable directly).
4. Finally, use "Group by" Lot and "Group by" Result, and create a new formula column based on "Result" column : New Formula Column>Aggregate>Sum. This will lead to this formula in the new column:
   

   Col Number( :Result, :Lot, :Result )

@ConfidenceOwl94 please find attached the datatable with the newly created column for the count of Pass/Fail. You can then use this column to calculate %Yield or directly transform the formula in this column to the following formula to get your Yield directly calculated :

(Col Number( :Result, :Lot, :Result ) / Col Number( :Result, :Lot )) * 100

Hope this solution may help you,