This content has been marked as final. Show 9 replies
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: