I have the following code and works but I want to SUM as is I get 3 values
CASE WHEN OrderReason='Disconnect' THEN COUNT(DISTINCT AccountCode) *-1 WHEN OrderReason='New Service' THEN COUNT(DISTINCT AccountCode) *1 WHEN OrderReason='New Account' THEN COUNT(DISTINCT AccountCode) *1 END
