3 Replies Latest reply: Mar 18, 2013 4:35 PM by Stefan Wühl RSS

    count null and non null values

    lin ye

      If I have a table like below

       

      product  week value

      1,           1,       null

      1,           2,       123

      2,           1,        333

      2,           2          444

       

       

      say I want to count values below 400 including nulls. I should get 3. how to include null values in counting?

       

      Thanks