Discussions
-
Business days only gets 72 hours not 96 as it should for 2 weekends 1,7 twice
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)…
-
beast mode below works but is erratic
((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
-
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
