how to write not null in the set analysis

[#1]

Hi All,

I have a requirement where in i have to add a condition like resolveddate is not null. Can someone help me how to implement this condition in the set analysis ASAP.

Thanks in advance,

Smitha

[#2]

Just say resolvedate = {"*"}

[ashfaq_haseeb]

Hi

Filtering Null is a tricky part.

You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.

=sum({$<resolveddate ={'*'}-{''}>} 1)

Regards

ASHFAQ