Set analyse problem

[#1]

HELLO!

I want to calculate the count (TYPE) with the set anayse definition as TYPE={SEL_TYPE_01,NULL}, where SEL_TYPE_01 is the name of a selection list, and NULL is a subset where TYPE is NULL.

The result is something like         count{<TYPE={SEL_TYPE_01,NULL}>TYPE}

If you have any idea or advice,

THANKS for your response !!!!

[#2]

hi

try this

aggr(count({<TYPE={''}>}TYPE),SEL_TYPE_01)

[er_mohit]

try this

count(distinct {<TYPE={0}>}TYPE)

or

count(distinct {<TYPE={' '}>}TYPE)

if you can't get the output then try this

aggr(count(distinct {<TYPE={0}>}TYPE),SEL_TYPE_01)

aggr(count(distinct {<TYPE={' '}>}TYPE),SEL_TYPE_01)

[narender123]

I dont get your point,

I think you want his

count{<TYPE={'SEL_TYPE_01'}>TYPE}

[#5]

Something like this:

=count ({SEL_TYPE_01} TYPE)+NullCount(TYPE)

[sujeetsingh]

Just go  for:

COUNT({<TYPE={SEL_TYPE_01},{TYPE=NULL}>TYPE)