Skip to Content
0
Mar 31, 2016 at 03:24 PM

Syntax for an if statement with calculation contexts

151 Views

Hello -

I'm looking for some syntax help. I don't know how to structure the syntax to give me a new field that will indicate if a student has taken BIO-157 with a passing grade before they took BIO-263.

I was guessing it should be something like this but then of course there is no 'when' clause available.

=IF ([Enrollment Start Date]) When ([Enrolled Course Name] = "BIO-157" and [Passing Grade]="Yes") FOREACH ([Enrolled Academic Credit Id])

< ([Enrollment Start Date] When ([Enrolled Course Name] = "BIO-263") FOREACH ([Enrolled Academic Credit Id])

then "Yes" Else "No"

Thanks for any help possible!