Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

help with expression

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

3 Replies
sunny_talwar

May be this:

RangeSum(

Count({<[Population Group Code] = {2}, [Date] = {">$(varMinSelectedDate)<=$(varSelectedDate)"}, [MonthYear] =, [Year] = , [BGMonth] =>} DISTINCT [Person ID])

Avg({1}0))

arusanah
Creator II
Creator II
Author

not working

Anonymous
Not applicable

Have you tried replacing the variables in the set analysis with the actual dates hard coded just to see if that makes a difference?