10 Replies Latest reply: Jan 18, 2011 10:44 PM by Anil Konduri RSS

    NOT MATCH in set analysis

    Anil Konduri

      Hi,

      I am replacing chart expression

      Count(DISTINCT if(Hours>0 AND Job <>1 AND NOT match(PersonID,1,2,20,21,22,23,24,25,26,27,28,29,998,999),Person_Name))

      by set analysis.... how to add NOT MATCH condition in set analysis expression. Ia m trying something like this

      =count({$<PaidDate=P(Date), Hours={'>0'}, Job={'<>1'}, PersonID{'<>{1,2,20,21,22,23,24,25,26,27,28,29,998,999}'} >} DISTINCT Person_Name)

      And also like this

      =count({$<PaidDate=P(Date), Hours={'>0'}, Job={'<>1'},PersonID={'=NOT MATCH(PersonID,1,2,20,21,22,23,24,25,26,27,28,29,998,999)'} >} DISTINCT Person_Name)

       

      Thanks in Advance