I am currently working on an expression using set analysis. The initial part works but then I also need to add a check for a date. The first part of the expression works where if the condition exists for each person in my chart, then I was to see "Yes" on the chart and if not then I see "No' on the chart. The RDS_Value here would either be 0 or 1 so if there is just one record for this type that is a 1, then I would see Yes. This part works by itself.
The second part that I am trying to include in the first expression is to check the dates. I need to check that the date that is associated with each record matches a particular date variable. If I check the dates in general with this expression, it works.
if
(RDSWeekValue=varWeek1Start, 1,0)
Now I just need to get these 2 expressions combined.