2 Replies Latest reply: May 17, 2012 6:40 PM by Aaron Couron RSS

    Scripting

    kushal141087

      Hi All,

       

      Can anyone tell me how to calculate privious 12 months sales in script.

        • Scripting
          Oscar Ortiz

          You're going to have to be a bit more specific if you want any help with this...

          • Scripting
            Aaron Couron

            Kushal,

             

            When creating my calendar table in my script, I usually have a line like this that creates a flag.

            IF(TempDate >=ADDMONTHS(MonthStart($(varToday)),-11),1,0) AS Current12MonthFlag,

            Then you can use set analysis to only pull sales for that flag:

            SUM({<Current12MonthFlag={1}>}Sales)

            Hope this helps!