Count number of distinct routes

[delbooth]

Hi .

I am trying to count the number of district routes for a given time ie current year and previous week.  I have tried the below where ColYear is master calendar data element and route is the field routes are located in.

count(distinct(if(ColYear={"$(=year(Today()))"},ColWeek = {"$(=Week(Today())-1)"},Route)))

Thanks

Del

[agigliotti]

maybe this:

count( {< ColYear={"$(=year(Today()))"},ColWeek = {"$(=Week(Today())-1)"} >} DISTINCT Route)

[delbooth]

Thanks