10 Replies Latest reply: Mar 30, 2010 11:01 AM by Miguel Angel Baeyens de Arce RSS

    problems with a count of nulls

      hi ...

       

      i have an expression on a pivot table

      =Count (if (date>=dateFrom and date<=DateTo), Field) //where dateFrom and DateTo are variables and Date the name of another filed.

      and the count give me always 0.

      i think is because the Field has NULLs. How can i filter the expression to don´t count the nulls??

       

      if anybody thinks that the problem is another i am open to all the answers...

       

      Thanks