Inspect the result, its parameters and the SQL behind it.
PricingCurrency, PricingCurrencyListUnitPrice, PricingCurrencyContractedUnitPrice and ServiceSubcategory are absent from the v1.0 sample, so savings in a virtual pricing currency cannot be computed.
SELECT
ServiceName,
ServiceSubcategory,
ChargeDescription,
BillingCurrency,
PricingCurrency,
SUM(PricingCurrencyListUnitPrice-PricingCurrencyContractedUnitPrice) AS ContractedSavingsInPricingCurrency,
SUM(ListUnitPrice - ContractedUnitPrice) AS ContractedSavingsInBillingCurrency
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND PricingCurrencyListUnitPrice > PricingCurrencyContractedUnitPrice
GROUP BY
ServiceName,
ServiceSubcategory,
ChargeDescription,
BillingCurrency,
PricingCurrency