How to exclude null values in set analysis

[#1]

I am trying to exclude null values from my set analysis equations below.  Below are my current equations,

CURRENT Set Analysis Expression:

Wins:

=count({$<StatusID={'$(vWonStatusID)'}, StatusSummary =>}DISTINCT IncidentID)

Loss:

=num(count({$<CreatedDate>}Distinct IncidentID), '#,##0')

-

count({$<StatusID={'$(vWonStatusID)'}, StatusSummary =>}DISTINCT IncidentID)

Total:

=num(count({$<CreatedDate>}Distinct IncidentID), '#,##0')

Thanks

[Anonymous]

Hi Toedtli,

add below code in script and replace field EmpID with your own fields:

if(Len(Trim(EmpID))= '0',1,0) as CountID.

add in UI:

=count({<CountID ={'1'}>} EmpID)

Regards

Neetha

[mato32188]

Hello T.,

change your variable into vWonStatusID = if(isnull(StatusID), 0, 'yourexpectedvaluelike1yesoranythingelse') if your statusID of wins is not 0 actually...

BR

M

[#4]

How are nulls formatted in your data?

[ruben_lima]

Hi, try this

count({<EmpID -={"$(=null())"}>} EmpID)

Regards

Ruben Lima

[jmvilaplanap]

If the null is in the set analysis you can compare it to '' (nothing)