Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
count(if({<[Population Group Code]={2},[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"},[MonthYear]=,[Year]= ,[BGMonth]=
>} DISTINCT[Person ID],0))
I need count of (Person ID) if above conditions is true else zero . somehow I am not able to put it thru . pls help
May be this:
RangeSum(
Count({<[Population Group Code] = {2}, [Date] = {">$(varMinSelectedDate)<=$(varSelectedDate)"}, [MonthYear] =, [Year] = , [BGMonth] =>} DISTINCT [Person ID])
Avg({1}0))
not working
Have you tried replacing the variables in the set analysis with the actual dates hard coded just to see if that makes a difference?