Count of Rows with Aggr Count ?

[itatspectrum]

Hello,

I have the following requirement. I have 1.3 million test records and I'm trying to get to a right first time percentage. Below I have the sample data. This will value will be going in a text box initially, but will also be used as an expression against the Station as well to see a % Right first time against each test station.

SerialNo	Station	Passed	TestNum
001	Pack1	N	9001
001	Pack1	N	9002
001	Pack1	Y	9003
002	Pack1	Y	9004
003	Pack1	Y	9005
004	Pack2	Y	9006
005	Pack2	N	9007
005	Pack2	Y	9008
Serial No 1 & 5 failed the first test, and needed to be retested
Right First Count	3
Total Items	5
Right First Time %	60%

Not sure what is the right tool for the job?

[Anil_Babu_Samineni]

I am not sure, What is your question?

Not sure what is the right tool for the job?

What does mean this?

[itatspectrum]

Hi Anil, by tools i really mean function. for example is it an aggr function, or an internal resident load, or a count if etc.

Steve

[trdandamudi]

Please see attached and hope this helps...