Forum Discussion
Calculating yield for production data
Hi all, I'm trying to calculate % yield for some test rig data. Each product, identified by a unique serial number goes through the test and gets a pass of fail result. What I want to do is use t...
Hi Anonymous ,
Thank you for your help! However this is returning a result of 100% and I'm expecting it to be just under that. How do I bring in the date/time element? I need to count the Pass results only for the serial numbers that have passed on the latest test.
Hope that makes sense.
Many thanks
Your requirements are not clear. Please give us an example of your calculations on an example table. I've tried several different scenarios and the yield always brings figures that are no less than 100%. You have to clearly explain what you want.
Best
D
Best
D