Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a formula that filters the products by those labelled as "Other" amoung the BrandNames included (real brands are changed to protect the guilty) but I want the same formula that excludes products with the description of "Other".
How do I do this, replacing = with <> doesn't work
Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products={'Other'} >} Sales)
Dave
hi there,
if the above expresssion is doesn't work then try this below exp :
Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products= {"*"}-{"Other"} >} Sales)
or
sum(if((BrandName = 'Shirts' or BrandName='Pants' or BrandName='Hats' or 'Shorts') and SeasonShort =vCurrentSeason and Products<>'Other' ,Sales)
hi there,
if the above expresssion is doesn't work then try this below exp :
Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products= {"*"}-{"Other"} >} Sales)
or
sum(if((BrandName = 'Shirts' or BrandName='Pants' or BrandName='Hats' or 'Shorts') and SeasonShort =vCurrentSeason and Products<>'Other' ,Sales)
This worked, Thanks!
Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products= {"*"}-{"Other"} >} Sales)