7 Replies Latest reply: Mar 2, 2017 12:38 PM by Jacek Stypulkowski RSS

    Count if

    Jacek Stypulkowski

      Hello,

       

      Can you help please?

      Looking for expression to count the Ref ID from those ClientID who appear in 2017 only leaving out those who appear in both years.

      The result coming form below example should be 3 as D and E appears only in 2017. Any ideas please?

       

      Ref IDClientIDYear
      1A2016
      2A2017
      3B2016
      4B2016
      5B2017
      6C2016
      7C2017
      8D2017
      9E2017
      10E2017

       

      Regards

      Jacek