SET ANALYSIS

[MK_QSL]

I want to count different part number having quantities greater than 0.

How to write in set analysis?

COUNT({Quantity > 0}Distinct [Part Number])

[swuehl · Accepted solution]

COUNT({<Quantity = {">0"} >} Distinct [Part Number])

[Anonymous]

Manish

Try:     COUNT ( { < Quantity = ">0" > ) Distinct [Part Number])

Best Regards,     Bill

[rustyfishbones]

Hi Swuehl,

How would it look if you wanted the SUM(Quantity)

would it be

COUNT({<SUM(Quantity) = {">0"}>} DISTINCT [Part Number])

or is it different?

[swuehl]

You can use only pure field names on the left side of field modifiers.

You can try something like

count( {< [Part Number] = {"=sum(Quantity)>0"} >} DISTINCT [Part Number])

[#6]

sth like with p() function

count({<[part Number] = p({1}<[part Number])  >} distinct [part Number])

or

count( {<[part Number] = {"=sum(Quantity)>0" } distinct [part Number]) )

Fabrice

[rustyfishbones]

thanks

[rustyfishbones]

I have a list box with 7000+ product codes

How do I only show the 900 codes that have sales,

[swuehl]

You can use the search bar on top of the list box

=sum(Sales)>0

or if you want to create a filtered list box, use a field expression:

=aggr( if(sum(Sales)>0,ProductCode), ProductCode)

or

=aggr(only({<ProductCode = {"=sum(Sales)>0"}>} ProductCode), ProductCode)

[rustyfishbones]

excellent thanks