- COUNT
=Count([SP Surrogate ID]) - RUNNING COUNT
=RunningCount([SP Surrogate ID]) - MIN and MAX
=Min([SE Term Code])=Max([SE Term Code]) - ENROLLMENT COUNT
="Enrollment count: "+Count([SP Surrogate ID]+[SE Class Number]) - IF THEN
=If[SE Division Descr] = "Division of Humanities" Then "Humanities" - IF THEN ELSE
=If[SE Division Descr] = "Division of Humanities" Then "Humanities"Else "Other" - IF THEN ELSEIF
=If[SE Division Descr] = "Division of Humanities" Then "Humanities"ElseIf [SE Division Descr] = "Colleges" Then "Col"ElseIf [SE Division Descr] InList ("Division of the Arts"; "School of Engineering") Then "Arts-Eng" - IF THEN & MATCH
=If (Match([SE Class Title] ; "*Chem*")) Then "Chemistry Class" - IF THEN & MATCH WITH AND
=If [SE Department Descr] = "Philosophy" And (Match([SE Class Title] ; "*Phil*")) Then "Phil" Else "not Phil " - IF THEN WITH OR
=If [SE Department Descr] = "History"Or [SE Department Descr] = "Legal Studies" Then "Top Two" - IF THEN WITH NOT
=If (Not ([SE Department Descr] = "History" Or [SE Department Descr] = "Legal Studies")) Then "NOT Top Two" - IN LIST
=If [SE Division Descr] InList ("Division of Humanities"; "Colleges"; "Division of the Arts"; "School of Engineering") Then "XX" - USER RESPONSE
=UserResponse("Enter value(s) for SE Term Code:")+" Student Count: "+Count([SP Surrogate ID]) (using template from parameter)=UserResponse("Term Code:")+" Student Count: "+Count([SP Surrogate ID]) (using customized parameter) - MATCH/WILDCARD WITH CHARACTER STRING – GIVES 1’S AND 0’S
=(Match([SE Class Title] ; "*Lab*"))