Set Analysis question , need a > then expression

[#1]

Hi,

Trying to write a set analysis statement but can't seem to find the correct syntax. Trying to do a rolling average based on week of year. User select the number of weeks to include and I want to select all week greater thenthe current week of year - the number of week to include

avg( {1<[Week of Yr] >= { $(#=week(Now())- $(numweeks)) } > } [2009 sales figures])

It works perfectly for a single week, but when I add the > I get all weeks of 2009.

Thanks In Advance

Michael

[johnw · Accepted solution]

You have to do the >= in the set expression itself. I think it would look like this:

avg({1<[Week of Yr]={">=$(=week(now())-$(numweeks))"}>} [2009 sales figures])

[#3]

thanks John!

that did it