rolling seven days in timescript

Sun, 30 Jun 2013 19:21:42 GMT

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

Re: rolling seven days in timescript

swuehl — Sun, 30 Jun 2013 20:44:25 GMT

For a rolling 7 days flag, you can use something like

if(Leveransdatum >= today()-7, 1,0) as R7_days