8 Replies Latest reply on Feb 5, 2016 1:30 PM by Fahri Akar

    Operator for "Includes" in a calculation

    ReynaldoRamirez

      Hello all!

       

      In my solution, I track student attendance from several sites.  Right now, I am able to filter a portal which will show me all student attendance across all sites based on the event date OR I can filter the portal to only show attendance based on a site that is selected in the Event_Dates table (it corresponds to the site in Student_Information_Attendance, which was copied from the Student Information table when I run a generate attendance script).

       

      The filter is as so:

      If (Event_Dates::Filter_by_all  =  "All"; Event_Dates::Date = Student_Attendance_ED::Date;

      Event_Dates::Site  =  Student_Information_Attendance::Site)

       

      This has been working great, but now I have a student that is in two sites. This student has two checkboxes checked in Student Information, so when the Site information is copied to Student_Information_Attendance::Site it has two site names with a line break in between.  For instance:

      Doral

      SFCPA

       

      How would I change the filter records calculation to show the attendance record if Student_Information_Attendance::Site includes any of the sites listed in Event_Dates::Site?

       

      Thanks,

      Rey Ramirez