3 Replies Latest reply: Mar 30, 2018 8:35 AM by Sunny Talwar RSS

    Count

    Michael Gauntlett

      Hi Guys,

       

      I have a requirement to be able to count the number of Orders where two conditions occur.

       

      for Instance

       

      the Number of Orders 'POMS' where the below conditions occur.

       

      sum(IF(OF_PA_Status='Approved by Customer',(IF(MSTATUS='R4',1,0)),0))

       

      so I am thinking

       

      Count([POM](IF(OF_PA_Status='Approved by Customer',(IF(MSTATUS='R4',1,0)),0))

       

      Would this work ? as a measure in the app, not in the script as a expression.