Count For user selected value?

[#1]

Hi,

Below is the code written for counting based on the selection of ActivityType.

Is it right or wrong?

=Count({$<ActivityYear = {2013},
ActivityMonth,
DueDate={"<=$(=Today())>"},
ActivityType={'$(#vActivityType)'},
ActivityWeek>} distinct Count

)

[#2]

Hey,

Should your distinct clause must not be just before set analysis ?  -->   Count(Distinct {<....>}Activity Week)