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!