Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How can i write this in set expression,Here my dimension is Product
sum(if(Product='Shoes',if(sales>1500,sales),sales))
Try this
Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)
Help me on this loveisfailvinieme12avinashelite
Regards
May be this
Sum({<Product = {'Shoes'}, sales = {'>1500'}>}sales)
try like this:
sum({<Product={'Shoes'}, sales={"=sales>1500"}>} sales)
hope this helps
Or may be this
Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)
Hi Bro,
If condition and set expression is giving different result.
like below
Try this
Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)
Not working what you people are provided
may be
sum({<Product={"=SUM({<Product = {'Shoes'}>}sales)>1500"} >}sales)
can you post your sample?