11 Replies Latest reply: Nov 29, 2011 1:17 AM by adjacentrock RSS

    Counting null values in a table

      Hi everyone,

      I am trying to use the count function to count the number of orders that do not have null value in its invoice date. I have tried a lot of what was already on the community like:

      =cout(distinct if(len(invdate)>0, key));

      = count( {$} KEY)

      = count(distinct if(isnull(INVDATE)=0, key));

      I am running out of ideas. Yet if I use the expression: = IF(INVDATE='', NOINVOICE), that works well proving that the QV identifies the missing date.

       

      Anyone?