7 Replies Latest reply: Sep 21, 2015 3:52 AM by PAUL YEO RSS

    Possible to compute last 5 month sales with out using partial load  ?

    PAUL YEO

      Hi All

       

       

      I want to compute last 5 month sales.

       

       

      Now i have YTD script which give Year To Date sales :-

       

       

       

       

        If(Num([date]) >= $(vYearStart) and Num([date]) < $(vMonthNow), -1, 0) As YTD,

       

       

      May i know how to modify the above script , so that it will return last 5 month sales amount.

       

       

       

       

      Hope some one can advise me ?

       

       

       

       

      Paul