) IS NULL THEN 0 ELSE SUM(V_LW_SKU_SLS.NetAmt) END AS LW_SALE_AMT, CASE WHEN SUM(V_LWLY_SKU_SLS.UnitsSold(V_LWLY_SKU_SLS.ShipQty) IS NULL THEN 0 ELSE SUM(V_LWLY_SKU_SLS.NetAmt) END AS LWLY_SALE_AMT, CASE WHENSUM(V_MTD_SKU_SLS.UnitsSold) IS NULL THEN 0 ELS