Calculation Involving Duplicates

Without deleting duplicates, how do I write a formula to calculate the total scrap percentage by date?   Scrap% = (Machine Scrap/(Machine Scrap + Good Quantity)) * 100   Production Day Machin...