Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I only want to count IDS, that have ONLY had temperature observations of 35
i.e
ID Obs Temp
1 1 35
1 2 35
1 3 35
2 1 35
2 2 36
2 3 35
2 4 37
3 1 35
3 2 35
3 3 35
3 4 36
I should only return ID 1
Please help
Sunny -
thanks for your reply. It is making more sense now. I am playing around with different aspects of this, changing temps and seeing the impact. It just puzzled me that this -> {=Temp=35} was functioning like Only(Temp).
Thanks again
It was working like this
{=Only(Temp) = 35}