9 Replies Latest reply: Mar 2, 2016 1:21 AM by V SUDHAKAR RSS

    Count NULL values using Set-Analysis

    Carlos Londono

      Hi,

       

      I'm trying to count the number of DISTINCT projects that have NULL values for a specific field. Not all projects have null values for this field and some projects might have more than one null value for the field.  I'm using this count in a straight table for a  Pivot Chart in NPrinting.  I'm getting either an "error in set modifier expression" or an invalid result.

       

      image.jpg

      This expression returns the modifier expression error:

       

           =Count(DISTINCT{$<isNull(TASK_NAME)>}PROJECT_ID)

       

      This other expression gives me the count of ALL projects not only the count of projects with NULL values for the field:

       

           =Count(DISTINCT{$<TASK_NAME ={0}>}PROJECT_ID)

       

      Thanks!