Set expression

[prabhas277]

Hi Experts,

From this table find out the product where count(sales) >0

How to write the set expression for that?

Thanks In advance

[prabhas277]

Sorry

Find out the product where count(sales)>1

[sunny_talwar]

May be this

Count(DISTINCT {<product = {"=Count(Sales) > 1"}>}product)

[ariel_klien]

Hi,

did you try if(count(sales)>0,1,0)

Ariel

[tresesco · Accepted solution]

Count({<Product={"=Count(sales)>1"}>}Product)

[prabhas277]

For that I am getting output 0

[sunny_talwar]

May be your field name is sales and not Sales... have you made sure that the field names are read correct?

Count(DISTINCT {<product = {"=Count(sales) > 1"}>}product)