4 Replies Latest reply: Jun 25, 2015 11:37 AM by Vinoth Rajan RSS

    Script level Calculation

    Vinoth Rajan

      Hi All,

       

            I have the following data:

       

      Week

      DimTarget Sales

       

       

      05-10-2015

      A1000
      05-10-2015B1500
      12-10-2015A1500
      12-10-2015B1200
      19-10-2015A2500
      19-10-2015B2000
      26-10-2015A1700
      26-10-2015B1100
      02-11-2015A3500
      02-11-2015B3100
      09-11-2015A3000
      09-11-2015B3900

       

      and so on.

       

      I have weekly target sales data.

       

      For each week, I have to calculate the average of next three weeks target sales in script level.

       

      Example:

       

      for Dim A and week 05-10-2015, I have to take average of next three months sales value for Dim A i.e

       

      average of these 3 values: 1500,2500,1700.

       

      Likewise I have to calculate for all the weeks.

       

      Is there any way to do this?

       

       

      Thanks in advance

       

      Regards,

       

      VR