           label_1_value,
           label_2_value,
           unit_price,
-          IF ( prices.unit_price = 0,
+          IF(prices.unit_price IS NOT NULL, IF(prices.unit_price = 0,
             0,
             CASE
             -- Divide by # seconds in a day to get to core*days == avg daily concurrent usage
-              WHEN LOWER(unit_type) LIKE "vcpu" THEN -1*SUM(cred.amount)/prices.unit_price / 86400
+              WHEN LOWER(unit_type) = "vcpu" THEN -1*SUM(cred.amount)/prices.unit_price / 86400
             -- Divide by # seconds in a day and # bytes in a GB to get to
             -- GB*days == avg daily concurrent RAM GB
               WHEN LOWER(unit_type) = "ram" THEN -1*SUM(cred.amount)/prices.unit_price / (86400 * 1073741824)
               ELSE NULL
-            END ) AS usage_amount,
+            END ), 0) AS usage_amount,
           SUM(cred.amount) AS cost,
           cost_type
         FROM

          sku_metadata
        ON
          u.sku_id = sku_metadata.sku_id
        JOIN
          prices
        ON
          TRUE

      3 ),
    -- sku_metadata temporary table captures information about skus, such as CUD eligibility,
    -- whether the sku is vCPU or RAM, etc.
    -- sku_metadata temporary table captures information about skus, such as CUD eligibility,
    -- whether the sku is vCPU or RAM, etc.
    sku_metadata AS (
    SELECT
      sku_id,
