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

    koushik.neelakantha

      Hello everyone,

       

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

       

      Logic:

       

      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.

       

      Regards,

      Koushik.

        1 2 3 Previous Next