Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!!!
hi
try this
aggr(count({<TYPE={''}>}TYPE),SEL_TYPE_01)
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)
I dont get your point,
I think you want his
count{<TYPE={'SEL_TYPE_01'}>TYPE}
=count ({SEL_TYPE_01} TYPE)+NullCount(TYPE)
Just go for:
COUNT({<TYPE={SEL_TYPE_01},{TYPE=NULL}>TYPE)