3 Replies Latest reply: May 27, 2016 5:54 AM by Joanna Seldon RSS

    only count column where only criteria is matched

    Joanna Seldon

      Hi

       

      I have basically a room, and temperature of the room is taken at intervals in the day

       

      Record ID Number    Date,               TestNumber,   HotCold

         1                         01/01/2015              1                 C

         1                         01/01/2015              1                 C

         1                         01/01/2015              1                 C

       

       

      Record ID Number    Date,               TestNumber,   HotCold

         2                         02/01/2015              1                 C

         2                         02/01/2015              1                 C

         2                         02/01/2015              1                 C

       

      Record ID Number    Date,               TestNumber,   HotCold

         3                         03/01/2015              1                 C

         2                         03/01/2015              1                 H

         3                         03/01/2015              1                 C

       

      I wish to count only number of distinct Record ID Number, that have only recoded C for that day, in this case above 2

       

      how can I amend the count expression to do this?

       

      please help