Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
From this table find out the product where count(sales) >0
How to write the set expression for that?
Thanks In advance
Count({<Product={"=Count(sales)>1"}>}Product)
Sorry
Find out the product where count(sales)>1
May be this
Count(DISTINCT {<product = {"=Count(Sales) > 1"}>}product)
Hi,
did you try if(count(sales)>0,1,0)
Ariel
Count({<Product={"=Count(sales)>1"}>}Product)
For that I am getting output 0
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)