1 Reply Latest reply: Jun 30, 2013 4:44 PM by Stefan Wühl RSS

    rolling seven days in timescript

    Bradley Coyne

      hi i have the following expression in the front end.


      i would like to add it to the timescript insteas.


      sum({<Leveransdatum={">=$(=AddMonths(Max(Leveransdatum-6),0))<=$(=Max(Leveransdatum))"}>}[Levererat Antal])


      does anyone have a rolling seven days in their time script.


      would today() -7 as R7_days be the equivalant?


      it would be much better in my front end to have [Levererat antal] * R7_days as i have done for the r12 month and R13- R24 months as well.