just a simple question about weighted averages to calculate average discount percent as weighted average based on quantity of each item.
Without weighting the average discount is 12.5%. But want to weight by qty. What is the best formula and where in the spreadsheet would i plug in the formula?
|
Without weighting the average discount is 12.5%. But want to weight by qty. What is the best formula and where in the spreadsheet would i plug in the formula?