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.

       

      Best,

      Brad