Setting a calculated field to 1

SELECT 
          Acode
        , CASE WHEN ISNULL(V1, 0) = 0 AND ISNULL(V2, 0) = 0 AND ISNULL(V3, 0) = 0 
                THEN 1
                ELSE SUM(ISNULL(V1, 0) + ISNULL(V2, 0) + ISNULL(V3, 0))
          END AS Target
FROM YourTable
GROUP BY Acode 

---

A Fan of SSIS, SSRS and SSAS