2 Replies Latest reply: Mar 7, 2013 5:28 AM by Nicholas Child RSS

    Totals with Set Analysis, bug or am I stupid?

      Hi all,

       

      I've got this expression to work out Total Market Share, trying to get it to work with a total for each month in a line chart.

       

      My expression:

      sum(Value)/
                sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total(<[Chart Periods]>Value))
      
      
      

       

      The weird thing is at the top of the expression editor it says: "Expression OK" but in the actual expression there is a red squiggly line under the last bracket (see above)

       

      Is my syntax wrong?

       

      Any help would be appreciated.

       

      Tx, Cindy