0 Replies Latest reply: May 29, 2009 4:49 PM by Carla Hertenstein RSS

    If statements and set analysis question

      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.

       

       

      if

       

      ( (numericcount({$ <RDS_Type = {DailyCount} >} RDS_Value )) >0, 'Yes', 'No')





      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.

       

       

      if

       

      (RDSWeekValue=varWeek1Start,if( (numericcount({$ <RDS_Type = {DailyCount} >} RDS_Value )) >0, 'Yes', 'No'),'No')





      This combination above however did not work. Any other suggestions? Thank you!!