E-commerce & Retail Analytics Path · Mission 15 of 30Medium
Refund-aware net revenue by month
Combine date-truncation, CASE-driven value mapping, and SUM. The 'paid orders count fully, partial-refunds count half, everything else zero' net-revenue cut that goes on every monthly P&L deck.