Home / InfoView (DWH) / Help & Training 4.3 / Common Infoview Formulas

Common Infoview Formulas

  1. COUNT
    =Count([SP Surrogate ID])
  2. RUNNING COUNT
    =RunningCount([SP Surrogate ID])
  3. MIN and MAX
    =Min([SE Term Code])=Max([SE Term Code])
  4. ENROLLMENT COUNT
    ="Enrollment count: "+Count([SP Surrogate ID]+[SE Class Number])
  5. IF THEN
    =If[SE Division Descr] = "Division of Humanities" Then "Humanities"
  6. IF THEN ELSE
    =If[SE Division Descr] = "Division of Humanities" Then "Humanities"Else "Other"
  7. 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"
  8. IF THEN & MATCH
    =If (Match([SE Class Title] ; "*Chem*")) Then "Chemistry Class"
  9. IF THEN & MATCH WITH AND
    =If [SE Department Descr] = "Philosophy" And (Match([SE Class Title] ; "*Phil*")) Then "Phil" Else "not Phil "
  10. IF THEN WITH OR
    =If [SE Department Descr] = "History"Or [SE Department Descr] = "Legal Studies" Then "Top Two"
  11. IF THEN WITH NOT
    =If (Not ([SE Department Descr] = "History" Or [SE Department Descr] = "Legal Studies")) Then "NOT Top Two"
  12. IN LIST
    =If [SE Division Descr] InList ("Division of Humanities"; "Colleges"; "Division of the Arts"; "School of Engineering") Then "XX"
  13. 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)
  14. MATCH/WILDCARD WITH CHARACTER STRING – GIVES 1'S AND 0'S
    =(Match([SE Class Title] ; "*Lab*"))