This content has been marked as final. Show 2 replies
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.