Set Analysis: check for isNull(field1) or isNull(field2)

[#1]

Hi All,

Set analysis is still a mystery for me.  I am trying to count the records in a table when either VASEndDate is null or when DisconnectDate is null.

I can get one or the other with this:

Count({$< VASEndDate = {"=Len(VASEndDate) > 0"} >} AcctNo)

I cannot determine how to 'or' them together.  I found a post that just listed the second filed inside the <>:

Count({$< VASEndDate = {"=Len(VASEndDate) > 0"} DisconnectDate= {"=Len(DisconnectDate) > 0"}>} AcctNo)

That is not working.

By the way, is Len()>0 the best way to look for Nulls?  It seems to work, but it bothers me...

[#2 · Accepted solution]

The heck with set analysis for this one...

Count(if(not IsNull(DisconnectDate) or  not IsNull(VASEndDate), AcctNo))

[sridhar240784]

Hi,

Check if the below expression helps you.

Count({$< VASEndDate = {"=Len(VASEndDate) > 0"}> * <DisconnectDate= {"=Len(DisconnectDate) > 0"}>} AcctNo)

Check the attached application for sample.

-Sridhar

[rohit214]

hi

try this also

Count(if(IsNull(DisconnectDate)='-1' or   IsNull(VASEndDate)='-1', AcctNo))

thanks&regards

rohit

[#5]

Correct me if wrong, but I think using "LEN() > 0" would mean it is NOT Null and "= 0" or "< 1" would indicate Null