0 Replies Latest reply: Jun 27, 2012 4:43 PM by lratz1234 RSS

    Parts No Sales Last 12 Months

      I am trying to find a list of parts that have no sales for the last 12 months. The first column I have which is working is the code below. I now have a second column where I want the same results as the first column but where the part type is a BSS.

       

      Parts with no sales last 12 months
       =if(sum({$<[Net Item Type]=,[MonthYearSort]=,[Item Type]=, [Margin Slider]=, [Transaction Type] = {'SLS'}, [Transaction Date]={">=$(vFirstOfMonthPY)<$(vToday)"}, [Net Package Type] = {'Bulk'}>}[Extended Sale])<>0,0,1)
       
       Parts with no sales last 12 months which have a part type of BSS
       =if(
      [Net Item Type] = 'BSS' and 
      sum({$<[MonthYearSort]=,[Item Type]=, [Margin Slider]=, [Transaction Type] = {'SLS'}, [Transaction Date]={">=$(vFirstOfMonthPY)<$(vToday)"}, [Net Package Type] = {'Bulk'}>}[Extended Sale])=0
      ,1,0)
      

       

      Each column works when they are the only column being shown, but when they are both shown at the same time the first column expression does not work anymore. The dimension is Part Number.