Analyze credit memos

FOCUS Versions

v1.3 v1.4

Context

Locate Service Provider-issued credit memos in billing data and analyze how each one reduces net spend.

FOCUS SQL Query

SELECT 
    ServiceProviderName,
    InvoiceId,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND ChargeCategory = 'Credit'
GROUP BY
    ServiceProviderName,
    InvoiceId

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail

FOCUS Columns

Service Provider Name Invoice ID Billed Cost Charge Period Start Charge Period End Charge Category

Previous Report spending across billing periods for a service provider by service category Next Analyze cost per compute service for a subaccount