5 Replies Latest reply: Dec 3, 2009 9:10 AM by Miguel Angel Baeyens de Arce RSS

    Help with Set Analysis Syntax


      I'm trying to create a chart which represents a change in growth. The calculation would compare sales for this quarter compared to sales in the same quarter of the prior year. To support this function I created a QuarterIndex field. For example:

      YearQtr QuarterIndex POSQty
      2009-Q3 11 15,000
      2008-Q3 7 10,000

      The formula is: (2009-Q3 POSQty / 2008-Q3 POSQty) - 1

      I tried this expression, but it doesn't work: (sum(POSQty) / sum( {$<QtrIndex= {"QtrIndex - 4"}>} POSQty )) - 1

      Can someone help me with the correct syntax?

      Thank you in advance for any help you can give. I'm open to any suggestions, since I've tried many variations over the past 3 days to no avail. I'm completely out of ideas.