SELECT
    fm.owneridname AS fullName,
    SUM(
        CASE
             WHEN fm.new_amountactual IS NULL THEN 0
             WHEN fm.new_tenderstatus = 100000002 THEN (fm.new_amountactual * (1 - 1 / proj.uds_revenuerate))
            WHEN fm.new_probability9 < 31 THEN (fm.new_amountactual * (1 - 1 / proj.uds_revenuerate)) * 0.07
           WHEN fm.new_probability9 < 51 THEN (fm.new_amountactual * (1 - 1 / proj.uds_revenuerate)) * 0.15
          WHEN fm.new_probability9 < 81 THEN (fm.new_amountactual * (1 - 1 / proj.uds_revenuerate)) * 0.5
         WHEN fm.new_probability9 > 80 THEN (fm.new_amountactual * (1 - 1 / proj.uds_revenuerate)) * 0.5
        ELSE 0
    END) AS result
FROM dbo.new_deliveryplan AS fm WITH (NOLOCK)
LEFT JOIN dbo.new_project proj ON fm.new_project = proj.new_projectId
WHERE
fm.owneridname IN (:fullName)
AND fm.new_techexpvalidated = 100000000
AND fm.new_rdvalidated = 100000000
AND fm.new_tenderstatus IN(100000003, 100000000)
AND (
    (fm.new_monthcode = MONTH(CONVERT(date, :startDate)) AND fm.uds_year = YEAR(CONVERT(date, :startDate)))
    OR (fm.new_monthcode = MONTH(DATEADD(MONTH, 1, CONVERT(date, :startDate))) AND fm.uds_year = YEAR(DATEADD(MONTH, 1, CONVERT(date, :startDate))))
    OR (fm.new_monthcode = MONTH(DATEADD(MONTH, 2, CONVERT(date, :startDate))) AND fm.uds_year = YEAR(DATEADD(MONTH, 2, CONVERT(date, :startDate))))
    )
AND (LEN(fm.uds_tendernumber) = 11 OR RIGHT(fm.uds_tendernumber, 2) = '/1')
GROUP BY fm.owneridname