19 Replies Latest reply: Jun 23, 2017 6:00 AM by Charlie Leo RSS

    convert if in to setanalysis

    Charlie Leo

      Hi All ,

      Help me convert the below if statement in to setanalysis.

       

      sum(if(vJCEKPI1='A' and Date>=DateCurrPeriodStart and DorC='C',DCAmount,

      if(vJCEKPI1='C' and Date>=DateCurrPeriodStart and DorC='C',DCCount)))

       

       

      Help Is Appriceated please....   

       

      Thanks

      Charleo