5 Replies Latest reply: Oct 1, 2015 4:38 AM by Anita Melbye RSS

    Getting a range in set analysis (variable + 11 months)

    Steve Zagzebski

      There are probably several ways to do but I need to return a sum of sales for a period equal to the value of a Year Month variable + 11 months.

       

      For instance:

      Year Month Variable = 201311 (which represents year and month)

       

      Data (yellow represents the 12 months data I need to sum -  201311 through 201410). Obviously the issue is with a Year Month field I can't just add 11 to the variable:

      CompanySales_YearMonthSales
      A2013095
      A20131010
      A20131115
      A20140520
      A20140625
      A20140830
      A20140935
      A20141240
      A20150145
      A20150250

       

      Thanks in advance,

      Steve