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

    Expression for previous weeks' sales calculation

      Hello,

       

      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!