Analyze credit memos
This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.2
Context
Locate provider-issued credit memos in billing data and analyze how each one reduces net spend.
FOCUS SQL Query
SELECT
ProviderName,
InvoiceId,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Credit'
GROUP BY
ProviderName,
InvoiceId