SELECT
  -- Labour Target
  ROUND(SUM(
    w.`labour_target` +
    (
      w.`labour_target` *
      CASE
        WHEN w.`property_code` IS NOT NULL THEN [property_uplift]
        WHEN w.`labour_target_uplift` IS NOT NULL THEN [labour_uplift]
        ELSE 0.00
      END
    )
  ), 2) AS `labour_target`,
  -- Labour Actual
  SUM(
    IFNULL(w.`transport_actual`, 0) +
    IFNULL(w.`labour_actual`, 0) +
    (
      ROUND(
        IFNULL(w.`labour_actual`, 0) *
        CASE w.`calculate_ni`
          WHEN 'Y' THEN [installs_ni]
          WHEN 'N' THEN 0.00
        END
      , 2) +
      ROUND(
        IFNULL(w.`labour_actual`, 0) *
        CASE w.`calculate_ni`
          WHEN 'Y' THEN [installs_hp]
          WHEN 'N' THEN 0.00
        END
      , 2)
    )
  ) AS `labour_actual`,
  -- Material Target
  ROUND(SUM(
    w.`material_target` +
    (
      w.`material_target` *
      CASE
        WHEN w.`property_code` IS NOT NULL THEN [property_uplift]
        ELSE 0
      END
    )
  ), 2) AS `material_target`,
  -- Material Actual
  ROUND(SUM(
    w.`material_actual` -
    CASE w.`property_code`
      WHEN 'C' THEN [combo_rebate]
      WHEN 'S' THEN [system_rebate]
      ELSE 0
    END
  ), 2) AS `material_actual`
FROM
  `cost_workcodes` w
WHERE
  (w.`job_no` = [jobno])