Using variables on the left side of the set expression

[Hope_AA]

I know this topic was discussed a lot but reviewing all what was written, I still cannot find an answer to my problem.

I have this  set analysis where my left argument is a variable checking that the average for client activity in the last 24 weeks is Zero, and I want to find the number of those clients.

count({<$(vAgrAvgClientCurrent24))={0}>} Distinct ClientID)

I also tried with an "if" statement but it didn't work.

can anyone help?

[rwunderlich]

What is the contents of vAgrAvgClientCurrent24?

-Rob

[Hope_AA]

Here it is:

aggr(avg(

{<[YearWeekNo.autoCalendar.Date]={'$(vMaxYearWeek)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear2)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear3)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear4)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear5)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear6)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear7)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear8)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear9)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear10)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear11)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear12)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear13)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear14)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear15)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear16)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear17)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear18)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear19)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear20)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear21)'}>+
<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear22)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear23)'}>+

<[YearWeekNo.autoCalendar.Date]={'$(vMaxYear24)'}>}

WeekCount),ClientID)

[dwforest]

Left side can't be a variable unless it evaulates to an expression where the left side is not variable:

VExp = 'ID ={1,2}'

Move the test to the right side and use a key as the left:

ID = "=Avg(Current24)=0"

[Hope_AA]

so how do I use that? in the set expression itself as

=count({<ID={$(vAgrAvgCurrentClient24)=0}>} Distinct ClientID) ?