1 Reply Latest reply: Jun 17, 2011 12:48 PM by Ravi Gantyada RSS

    How to write in Set Analysis

      Hi All,

      Though its Friday, but still I am here to bug and buzz.

      How do i write this following statement in set analysis,

       

      sum(total if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND STAGE<> 'Lost' AND STAGE <> '-' AND STAGE <> 'Expired' AND STAGE <>'Design Win' AND STAGE <> 'Project Cancelled',TOTAL_VALUE))

       

       

      Thanks,

      Bikash