Count KPI based on a condition

[mansoorsheraz]

Hi All,

I have ran into a problem where I need to have the count in the KPI based on a condition as described below:

I have 1184 count coming for the facilities but out of them 504 have organization as null or blank

I can suppress the nulls here to get the count to exactly what I need i.e.  680 but the same I am, unable to achieve in the multi KPI i.e.

I have tried on a few things but they didn't work out. I came to know that we cannot use any function on the left hand side of the Set analysis as well. Any help is appreciated in achieving this.

Regards.

[BrunPierre]

As follows

Count({$<Organization ={"=Len(Trim(Organization ))=0"}>} Facilities )