/* Fee Transfer Paid — grand totals (DatawarehouseNCM) */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @PaidInvoices TABLE (InvoiceNo varchar(21) PRIMARY KEY); INSERT INTO @PaidInvoices (InvoiceNo) SELECT DISTINCT InvoiceNo FROM dbo.FactFeeTransferPaid WHERE RowSource = 'Paid' AND TrxDate >= @StartDate AND TrxDate <= @EndDate; SELECT COUNT(DISTINCT f.InvoiceNo) AS InvoiceCount, SUM(f.Amount) AS NetFeeAmount, SUM(CASE WHEN f.RowSource = 'Paid' THEN f.Amount ELSE 0 END) AS PaidInvoiceAmount, SUM(CASE WHEN f.RowSource IN ('CM', 'CMHistory') THEN f.Amount ELSE 0 END) AS CreditMemoAmount FROM dbo.FactFeeTransferPaid f INNER JOIN @PaidInvoices p ON p.InvoiceNo = f.InvoiceNo;