Case when Days Calculation_Trouble3 = 'Business Days' then SUM(ROUND(DATEDIFF(End Date2, Start Date2) * 0.7142164 + CASE WHEN WEEKDAY(End Date2) IN (1, 7) THEN 1 ELSE 0 END * 0.5004537 + CASE WHEN WEEKDAY(Start Date2) IN (1, 7) THEN 1 ELSE 0 END * -0.2910912 + 0.4646935,-0.2910912 + 0.4646935)) / COUNT(DISTINCT LocateID)…
((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
