How to Calculate Cumulative Percent Failures?
Hi all, I have a problem that I have been looking at for a couple days now and I can not quite get it to work. I would like to calculate the cumulative percent failure of a certain product in my table. :: Cumulative Percent Failure Example: If you had 100 product shipped, and every month 10 units failed, you would have 10% failure the first month, 20% the second, and so on. The fields in my table that I am concerned with are [Ship Year], which tells me what year the model shipped, [Model Number] which tells me which product line I am looking at, [QUANTITY] which tells me how many of the units from the product line there are (units produced), [M2F] which tells what month I am on (months to fail), and [SumOfDETAIL_QTY] which tells me how many units failed for that month. Key factors: • There is more than one product line in the table (1-30 possible) • I need to only consider cumulative failures among alike product lines I will include what I have done so far: Here is the SQL code I am us
