count number of weeks with set analysis

[Anonymous]

Hi,

I'm trying to establish how many weeks a datespan contains and i don't get why the following set analysis doesn'r work:

count(Date= {">=$(=monthstart(AddMonths(Today(),-12)))<=$(=monthend(addmonths(Today(),-1)))"} >} distinct(YearWeek))

Pleas help.

Thanks!

//A.

[Anonymous]

hi

try this

(WeekStart(date1) - WeekStart(date2))/7

[jagan]

Hi,

In script you create a new column like

Week(Date1) & '-' & Year(Date1) AS WeekYear

If you have the above column you can easily calculate the number of weeks by using the simple expression

=Count(DISTINCT WeekYear)

Hope this helps you.

Regards,

Jagan.