((SUM(CASE WHEN Disconnects IS NULL THEN 0 ELSE Disconnects END)) / (SUM(SUM(CASE WHEN ServiceStatusValue IS NULL THEN 0 ELSE ServiceStatusValue END)) OVER (ORDER BY BillingPeriod) + SUM(CASE WHEN Unique Count ServiceID IS NULL THEN 0 ELSE Unique Count ServiceID END))) * -1
SUM(served) OVER (PARTITION BY Physical County,CABINET) / Sum(Passed) OVER (PARTITION BY Physical County,CABINET )*100
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
