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


    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.