2 Replies Latest reply: May 30, 2013 3:15 AM by Deepak Kumar RSS

    Absolute Average

    Deepak Kumar

      Hi All,

       

      I need Help, Requirement is we looking for absolute Average. Case is that suppose a customer the product every month.for example customer sell the Product in April,June ,July and August then you want to find out the average .So logic is that for the Average is you have to consider the month may also for finding the average.

       

      Any help would be appreciated.

       

      Thanks in advance.

       

       

      Regards

      Deepak

        • Re: Absolute Average
          Gysbert Wassenaar

          Something like this: sum(Sales)/(max(month)-min(month)). If you don't have a numeric month field you'll have to create one. If you have a salesdate then calculating it in the script is the easiest way to create it: month(salesdate) as month

            • Re: Absolute Average
              Deepak Kumar

              Hi Gysbert,

               

               

              Thanks for Reply. but scenario is that Suppose in 2012-13, Customer is created in June ,Invoice is generated  or delivered in the Aug,Sept,Oct,Dec. I want to show the Absolute Average from June to Dec.i.e Sum(dispathchQty)/no of months(June-dec).

               

               

              Please Give me sum Idea.

               

              Regards

              Deepak