We have a primary table used to track student information (“Students1”). We also have a connected table that stores related assessment and outcome records (“Assessments”). Each record in the “Students1” table will have multiple related records from “Assessments” that appear in the Students1 table in a list column.
I am able to successfully create an expression that checks whether a particular value is present in any of the related assessment records for a particular student. For example:
Contains([Related Assessments][Pre or Post], “post”)
If I understand correctly, this expression will check to see whether any of the student’s Related "Assessments records contains “post” in the [Pre or Post] column. Basically, does the student have a posttest.
Now, I want to create an expression that checks whether any one of the related rows has both a value of “post” in the [Pre or Post] column, and does not contain a “+” in the [Score] column. Does anyone have any advice on how to do this? Or maybe a resource you could link to?
The best I can come up with is:
Contains([Related Assessments][Pre or Post], “post”),
NOT(Contains([Related Assessments][Score], “+”))
However, I don’t think this works. For a particular student record, one related row might have “post” in [Pre or Post], and a second related row might not have “+” in the [Pre or Post] column. In that case, the expression would evaluate to true, right? But I want it to only evaluate to true if both of these conditions are true for a single row/record.
Thanks for reading, and for any advice you might have.