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.




      [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.