please find the query as below

DECLARE @DrillSelected VARCHAR(100)

if @DrillSelected is null

begin

select D.BUSINESSDIVISION,

(SUM((nL.baseval)*CASE WHEN CURR.RATE IS NULL THEN 1 ELSE CURR.RATE END)) OUTSTANDINGAMOUNT

FROM

vw_fact_nltrans nl

INNER JOIN

VW_DIM_COMPANY C

ON nl.COMPANY_sk=C.COMPANY_sk

INNER JOIN DIVISIONMAPPING D

ON D.COMPANYID=C.COMPANYID

INNER JOIN VW_DIM_EXPENSECODE EC

ON NL.COMPANY_SK=EC.COMPANY_SK AND NL.EXPENSE_SK=EC.EXPENSE_SK

LEFT OUTER JOIN VW_FACT_CURRENCY CURR

ON c.COMPANY_SK=CURR.COMPANY_SK

AND CURR.CURRENCY IN ('GBP','STER') where d.active in ('yes','no') and

nl.yearno in (select distinct fiscalyear from VW_DIM_FISCAL_CALENDAR_PERIOD where periodid='201302') and nl.periodid<='201302' and (EC.EXPENSEGROUP IN ('1-###-##','2-###-##','3-###-##') OR EC.EXPENSECODE='4-030-04') AND C.COMPANY_DESC NOT IN ('Advanced Health & Care NZ Ltd')

group by D.BUSINESSDIVISION

end