1 2 3 Previous Next 31 Replies Latest reply on Aug 3, 2018 4:45 AM by Mahfooj Khan

    Calculating Average sales for preceding months


      Hello everyone,


      I have a month parameter which has values from Jan 18 to Sept 18. Currently i am in July month.




      1. Calculate the YTD  by averaging the values for preceding months
        1. Example: It's July so I would expect my Sales to be an average of the monthly Sales values for Jan 2018, Feb 2018, Mar 2018, Apr 2018, May 2018, and Jun 2018.


      Help me out.




        1 2 3 Previous Next