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

    Count NULL values using Set-Analysis

    Carlos Londono



      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.



      This expression returns the modifier expression error:




      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)