Tableau practice: Conditional aggregations and target ratios

Create Sheets Sales: sum Sales only when Category is 'Sheets': SUM(IF [Category] = 'Sheets' THEN [Sales] ELSE 0 END).

Create Discounted Share: sales where Discount > 0 divided by total sales: SUM(IF [Discount] > 0 THEN [Sales] ELSE 0 END) / SUM([Sales]).

Create Attainment: total sales divided by the sales rep quota target: SUM([Sales]) / ATTR([Annual Target]).

If a sales rep with a ₹1,000,000 quota has 50 order lines in the data, what happens if an analyst computes SUM([Sales]) / SUM([Annual Target])?

Create Weighted Discount: revenue-weighted average discount computed as SUM([Sales] * [Discount]) / SUM([Sales]).