6 Replies Latest reply: Feb 26, 2013 7:08 AM by sudeep dhoju RSS

    count issue

    sudeep dhoju

      contract   yearmnth     type

      123             201206      a

      123              201205     b

      123               201204    c

      543               201209    d

      543               201209    e

      543              201208     f

       

      In the above e.g, i want the count as 1 for contract 123 since the max month is appearing once i.e 201206

         but in 543,count should be 2 since maxmonth for this contract appears twice.. i.e 201209

       

      Please suggest me the required expression.

      Thanks