Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
As follows
Count({$<Organization ={"=Len(Trim(Organization ))=0"}>} Facilities )