11 Replies Latest reply: Jan 27, 2017 12:12 PM by Sunny Talwar RSS

    Rolling sum Syntax help

    Eli Karp

      Hello All,

       

      I'm looking for some sytanx help.  I have a value in January that is loaded with the base number for the year. In the following months the change in that number is expressed. So in January I have 500 and in February I could have 2, with a total of 502. Than in march my value could be -3 leaving a total of 499. I want a dynamic way to show that 502 throughout the year. I know I need to create a variable for start as like 1.1. and using the year date. but I'm having trouble with the end date and how to construct the set analysis.

       

       

      Thanks,