G
GillesABelanger
Good afternoon, My brain is stumbling on this issue: this inbound audit
databse is capturing the defects found for each trailer number. In each
trailer I have a given number of tickets that we must check.
In order to calculate the Defect per Million , I need to add the number of
ticket that were received in a selected time window. I am trying to use a
Pivot Table hoping to convert it to a dap later.
That would allow the user to calculate their DPMU for any period of time
they would select in the top part of the Pivot Table. For instance:
Trailer # TotalNuOfTicket Defect found
123 52 1
235 45 2
552 39 3
I need to do the folowing math: (1+2+3) /(52+45+39)*1,000,000
The problem is to add the total number of tickets received, I am always
having 52+2*45+3*39 to compare with 1+2+3.
I need to have (1+2+3) /(52+45+39)
How can I add the TotalNuOfTIckets fro each trailer without couting them as
many times as I found defects in that trailer?
I hope this is clear.
Thanks
databse is capturing the defects found for each trailer number. In each
trailer I have a given number of tickets that we must check.
In order to calculate the Defect per Million , I need to add the number of
ticket that were received in a selected time window. I am trying to use a
Pivot Table hoping to convert it to a dap later.
That would allow the user to calculate their DPMU for any period of time
they would select in the top part of the Pivot Table. For instance:
Trailer # TotalNuOfTicket Defect found
123 52 1
235 45 2
552 39 3
I need to do the folowing math: (1+2+3) /(52+45+39)*1,000,000
The problem is to add the total number of tickets received, I am always
having 52+2*45+3*39 to compare with 1+2+3.
I need to have (1+2+3) /(52+45+39)
How can I add the TotalNuOfTIckets fro each trailer without couting them as
many times as I found defects in that trailer?
I hope this is clear.
Thanks