only count column where only criteria is matched

[joeybird]

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

[Anonymous · Accepted solution]

Hi

Please find attached QVF with expression Count({<HotCold={"C"}>}distinct([Record ID Number]))

and filter with Date..

Thanks

[sunny_talwar]

What is the output that you expect to see?

[joeybird]

thank you x