Please solve below Query

select SUM(currenttotalreps) totalreps
from (
Select isnull(dateadd(day,-day(coalesce(c.originaldate,c.reconciliationdaterun))+1,
CAST(DATEDIFF(DAY, 0, cast(COALESCE (c.OriginalDate,c.ReconciliationDateRun) AS datetime)) AS datetime)),'1/1/1900')AS AsOfDate
, Territory = (
SELECT DISTINCT RepID
                ,  HR.TerritoryNum TerritoryID
                ,   HR.DateFrom DateFrom
                , DateTo = MAX( CASE WHEN HR.DateTo = '1/1/1900' THEN GETDATE() ELSE ISNULL(HR.DateTo, GETDATE()) END )
             FROM HistoryRepTerritory HR
             WHERE EXISTS (SELECT 1 FROM TerritoryHierarchy inner join TerritoryHierarchy t on HR.TerritoryNum= t.Id)
             group BY HR.TerritoryNum, RepID, HR.DateFrom)
,r.active,currenttotalreps = 1
            , RepsWithNoResponse =CASE WHEN C.RepID IS NULL THEN 1 ELSE 0 end
, ReconciledToZero  = CASE WHEN  c.FinalStatus = 'Reconciled to Zero' AND C.RepID IS NOT NULL  THEN 1 ELSE 0 END
, ReconciledToThreshold = CASE WHEN  c.FinalStatus = 'Reconciled Within Allowable Threshold' AND C.RepID IS NOT NULL THEN 1 ELSE 0 END
, ReconciledToProductGroup= CASE WHEN  c.FinalStatus = 'Reconciled By Product Group' AND C.RepID IS NOT NULL THEN 1 ELSE 0 END
, NotReconciled = CASE WHEN  c.FinalStatus = 'UnReconciled' AND C.RepID IS NOT NULL THEN 1 ELSE 0 END
, Negative = CASE WHEN  c.FinalStatus = 'UnReconciled with Negative Variance' THEN 1 ELSE 0 END
, Incomplete = CASE WHEN c.FinalStatusCompliance = 0 AND c.FinalStatus IS NULL  AND C.RepID IS NOT NULL THEN 1 ELSE 0 END
FROM dbo.Reps r (NOLOCK)
INNER JOIN dbo.Auxiliary_SARoster SR (NOLOCK) ON R.RepID = SR.RepID
inner JOIN  dbo.Auxiliary_ReconciliationCheckList C (NOLOCK) ON R.RepID = C.RepID
where CAST(DATEDIFF(DAY, 0, cast(COALESCE (c.OriginalDate,c.ReconciliationDateRun,'1/1/1900') AS datetime)) AS datetime)
between '1/1/2014' and '12/31/2014') sq
where exists(SELECT 1 FROM TerritoryHierarchy inner join TerritoryHierarchy t on sq.territory= t.Id)