5 Replies Latest reply: Apr 24, 2013 6:47 AM by Narender Makhija

# Set analyse problem

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,

• ###### Re: Set analyse problem

hi

try this

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

• ###### Re: Set analyse problem

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)

• ###### Re: Set analyse problem

I think you want his

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

• ###### Re: Set analyse problem

Something like this:

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

• ###### Re: Set analyse problem

Just go  for:

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