How to check for Null values in set expression

[#1]

Hi,

I have to count ext_id for those having Segment as null.

So in expression I wrote count({< Isnull(Segment)>} ext_id)

but it's not working.

Regards,

Tanay

[sunny_talwar]

May be this

Count({<ext_id = {"=Len(Trim(Segment)) = 0"}>}ext_id)

[vishsaggi]

Can you write this Sunny?

= Count({<ext_id -= {" * "} >} ext_id)

[sunny_talwar]

We are not checking for a null condition on ext_id.... why use this? ext_id -= {" * "}

[vishsaggi]

OOps ignore. I got that. Sorry.

May be this: ?

= Count({< Segment -= {" * "} >} ext_id)

[sunny_talwar]

But the requirement is to count ext_id where Segment is null

[oscar_ortiz]

Have you tried the NullCount(ext_id) function?

Good luck

Oscar

[oscar_ortiz]

NullCount(Segment)

[vishsaggi]

You are right it should be segment.

[arjakumar]

This one may works

Count({<Segment = {'Isnull(Segment)'}>}ext_id)