0 Replies Latest reply: Jul 1, 2011 12:29 PM by Bikash Debnath RSS

    Isnull in set analysis

      Hi All,

      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))

       

       

       

      Thanks in advance,

      regards,

      Bikash