3 Replies Latest reply: Mar 27, 2013 6:21 AM by Sokkorn Cheav RSS

    Set Analysis - AND condition



      Please help me to get the count of Id's which have the records in Either 'On Hold' column OR 'Cancelled' Column...


      I wrote the expression as below, but it is giving me only the data based on AND condition


      Count({$<Month={'31/01/2013'},[On Hold]={1},[Cancelled]={1}>}[ID])


      Please suggest me...