2 Replies Latest reply: Oct 14, 2012 6:12 AM by snpnassar RSS

    Four Week Average at Script Level

      Hello Stefan,

       

      Script is working fine for the example you had shared earlier where I had  numbers.

       

      However when i apply the same script to big numbers i am not getting the desired results in QV.

       

      I have attached excel file for your reference, where red font shows the results coming for four week averages in QV. And below is the script used.

       

      LOAD

       

      [Fiscal Week Ending],
      [Sales Out $],
      Rangesum([Sales Out $],peek([Sales Out $],-1),peek([Sales Out $],-2),peek([Sales Out $],-3))as myRollingAvg

       

      Request you to provide your view on this.

       

       

      Nassar