3 Replies Latest reply: Oct 2, 2011 8:10 AM by Stefan Wühl RSS

    Expression for previous weeks' sales calculation



      I am currently using the following expression to display current and previous 6 weeks' ytd sales figures


      =sum({$<WK_NUM= {"<=$(=Selected_Week) >=$(=Selected_Week-6)"}>} sales_ytd)/1000


      I need to implement the same logic when calculating wtd sales figures for the current and previous 6 weeks. The way I derive a week-to-date sales figure is (e.g for wk 13): = WK 13 YTD - WK 12 YTD.


      Help will be much appreciated.


      Thank you!