How to show certain values in a List Box??

Anonymous — Wed, 30 Sep 2015 17:42:36 GMT

=if((count({$< [Product ID]={"=count ({< Status={ACTIVE} >}DISTINCT UPC_CODE)=2"}>} Distinct [Product ID])-

count(Aggr(IF(COUNT(DISTINCT UPC_CODE)=2 and Status='ACTIVE',[Product ID]),[Product ID])))=1,[Product ID])

How to show only those values in a list box that satisfies the above condition? So my expression calculates

the number of productID when AGGR Exp is subtracted from Set Analysis Exp. What I need is to identify Product IDs

that are not captured by AGGR function. It is working ok when I put the above Expn in the Expression of list box

and sort it by Expression. But what I really need is for the list box to show only those Product IDs that are not

captured by AGGR function, which is the same as satisfying the expression I have above.

Re: How to show certain values in a List Box??

Anonymous — Fri, 02 Oct 2015 15:24:31 GMT

anyone? swuehl‌ or sunindia‌ ??