How do I write this following statement in set analysis,
sum(if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND LINE_ITEM_STATUS='Design In' AND REVENUE_RECOGNITION_FLAG='Yes' AND isnull(DESIGN_WIN_DATE) AND
date(DESIGN_IN_DATE)>='03/29/2010' AND date(DESIGN_IN_DATE)<='04/03/2011' AND IS_PART_ACTIVE='1', DESIGN_IN_DATE-CREATED_DATE))
+
sum(if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND LINE_ITEM_STATUS='Design Win' AND REVENUE_RECOGNITION_FLAG='Yes' AND
date(DESIGN_WIN_DATE)>='03/29/2010' AND date(DESIGN_WIN_DATE)<='04/03/2011'AND IS_PART_ACTIVE='1', DESIGN_WIN_DATE-CREATED_DATE))
