Null count in straight table

[clondono]

Hello,

I’m trying to get a COUNT of DISTINCT Projects with Tasks missing Facility Name.

I can get then listed correctly in the “Task Missing Facility Name” table using this expression:

=if(len(trim(TASK_FACILITY))=0, '**UNASSIGNED**', TASK_FACILITY)

It puts the **UNASSIGNED** text for TASK-FACILITY for all tasks missing the facility name.

The issue is when I try to “count” the number of projects with tasks missing facility names.

I’m using this formula:

Count(DISTINCT{$<Flag_NullTaskSeq = {"=NullCount(TASK_FACILITY)>0"}>}REQUEST_ID)

Which seems to work fine, but for some strange reason it doesn’t return the correct value for some PMs.

For example, no filters applied the PM listed below (D) is showing 1 project missing facility name ( which it is not correct).  If I select D as the responsible PM it changes to 0 which is the correct value.

Any ideas how to handle these null counts?

Thanks!

Message was edited by: Carlos Londono I'm including a sample file with 3 tables, the 2 upper tables return the correct results. When I combine the fields in the lower table (to export to NPrinting for a Pivot chart) one of the fields returns the wrong count. Any ideas on how to solve this issue? Thanks!

[sunny_talwar]

What happens if you use this:

Count(DISTINCT{$<Flag_NullTaskSeq = {"=Len(Trim((TASK_FACILITY))>0"}>}REQUEST_ID)

[clondono]

Sunny using the expression you suggested returns zero for all counts

[Anonymous]

The Aggr() function may well help.