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...
First calculate total count.
Total_count=calculate(Count(table[serial_number]),Allexcept(table,serial_number))
It will return total count for each serial number.
Then check how many serial number have pass status.
Total_count_Pass=calculate(Count(table[serial_number]),Allexcept(table,serial_number)),filter(table,table[testoutcome]="Pass").
Pass percentage=Divide(Total_count,Total_count_Pass,0)
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.