List Box Only Products that have Sales >0

[rustyfishbones]

Hi All,

I have done this in the past, but I am missing something.

Anyone have a list box expression that only shows products that have Sales greater than 0

Regards

Alan

[rustyfishbones]

I have the following

=AGGR(ONLY({<Product = {"=SUM([adj-prime])>0"}>} Product), Product)

Is there a better way!

[rustyfishbones]

I have also tried this

Still no joy

[miikkaqlick · Accepted solution]

=If(Aggr(Sum(Line),Prod)>0,Prod)

Br,

Miikka

[rustyfishbones]

Thanks Miika