Calculating percent complete

Thedda

Registered User.
Local time
Today, 00:46
Joined
Aug 2, 2002
Messages
16
I have a database that counts how many work orders have been completed by date. Here is an example of the data.

Work Order - Date Complete -Qty Complete - Work Order Qty
20001 - 9/2/09 - 5 - 50
20001 - 9/3/09 - 25 - 50
20001 - 9/4/09 - 15 - 50
20001 - 9/5/09 - 5 - 50
20002 - 9/2/09 - 50 - 75
20002 - 9/3/09 - 25 - 75

What I need to know is the date the orders completed at >=85% of total work orders. For example work order 20001 would have completed 85% on 9/4/09. I appreciate any help you can give me on this.

:confused:
 
if you want my opinion, htis doesn't make sense. the data can't be read like that. i dont' understand it myself.
 

Users who are viewing this thread

Back
Top Bottom