Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What is the contents of vAgrAvgClientCurrent24?
-Rob
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)
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"
so how do I use that? in the set expression itself as
=count({<ID={$(vAgrAvgCurrentClient24)=0}>} Distinct ClientID) ?