topic Re: Count no of entry in column to calculate yield. in Discussions

Count no of entry in column to calculate yield.

ConfidenceOwl94 — Mon, 24 Nov 2025 20:40:34 GMT

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)

Re: Count no of entry in column to calculate yield.

Victor_G — Tue, 25 Nov 2025 08:01:47 GMT

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".

Re: Count no of entry in column to calculate yield.

hogi — Mon, 24 Nov 2025 21:28:09 GMT

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/910592/highlight/true#M106966

Re: Count no of entry in column to calculate yield.

hogi — Mon, 24 Nov 2025 21:10:59 GMT

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

Re: Count no of entry in column to calculate yield.

hogi — Mon, 24 Nov 2025 21:23:31 GMT

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

Re: Count no of entry in column to calculate yield.

Victor_G — Tue, 25 Nov 2025 07:57:26 GMT

Hi @hogi,

It is possible but require some work on the datatable:

Recode Pass to value "0" and Fail to value "1"
Change column "Result" data type to Numeric and Modeling type to "Nominal"
Add a column property "Value Labels" to identify what the 0s and 1s mean (and display it in the datatable directly).
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,