3 Replies Latest reply: May 1, 2013 6:44 AM by Naweed Alam RSS

    Counting records with conditions across different rows

    Naweed Alam

      Hi Guys i have the attached scenario and i need a quick solution, i have given the excel example in the attached.

       

      I have a group of records. 1 record has multiple lines identifing the types so the record ID repeats for every Type and Oper see attached.

       

      i want to count the reordID which contains type of F and Oper=0010 which is straight forward

      i then want to count the records ID that contains a line where Type =F and Oper=0010 and also contains type =X on any line where Oper>0010.

       

      Any replies/samples would be appreciated