Absher_645

Discussions

I need to convert the following beast mode to Group by
SUM(served) OVER (PARTITION BY Physical County,CABINET) / Sum(Passed) OVER (PARTITION BY Physical County,CABINET )*100
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