2 Replies Latest reply: Oct 29, 2013 10:35 PM by David Coad RSS

    Set Analysis <> function

      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