6 Replies Latest reply: Jul 22, 2014 2:28 AM by jagan mohan rao appala RSS

    Rolling 6 Month Sum in Scripting

    BAIKANG CHEN

      Hi:

       

      Can anyone teach me how to do rolling sum in scripting level?

       

      I understand how to use RangeSum and Above functions in the expression but Above is not available in the scripting.

       

      Thank you very much in advance.

       

      PC

       

      PS: Here are two examples.

      It would be great if I can do something like this:

      DateHead CountRolling 6 Month Head Count
      01-01-201311
      01-02-201312

      01-03-2013

      13
      01-04-201314
      01-05-201315
      01-06-201316
      01-07-201316
      01-08-201316
      01-09-201316
      01-10-201316
      01-11-201316
      01-12-201316
      01-01-201405
      01-02-201404
      01-03-201403
      01-04-201402
      01-05-201401
      01-06-201400

       

      Another example would be:

      DateHead CountRolling 6 Month Head Count
      01-01-201311
      01-02-201312

      01-03-2013

      13
      01-04-201314
      01-05-201304
      01-06-201304
      01-06-201303
      01-07-201302
      01-08-201301
      01-09-201300