Skip to main content
Bonterra Help Center home page
  • Submit a request
  • Sign in
  • Sign in
  • Submit a request
  1. Bonterra
  2. ETO
  3. Help Articles
  4. Reporting in ETO
  5. Functions and Formulas

Functions and Formulas

  • ETO Results | Create New Variable
  • ETO Results | Link TouchPoints to Enrollment
  • ETO Results | Hyperlink to Edit Sub Form TouchPoint Response (Flattened Data)
  • ETO Results | Date Taken in Fiscal Year Quarters
  • ETO Results | Hyperlink to Participant Dashboard
  • ETO Results | Hyperlink to View, Edit, or Add TouchPoint Response
  • ETO Results | Link to Enroll Participant
  • ETO Results | Variable Qualifications
  • ETO Results | Retrieve First or Last Name from Subject Name
  • ETO Results | Functions: Left and Right
  • ETO Results | Convert Date or Number to String
  • ETO Results | Formula: Strip Pipe Character (|) From Value
  • ETO Results | Functions: Upper, Lower, Initcap, Wordcap
  • ETO Results | Incorrect Averages
  • ETO Results | Formula: Display Non-Exclusive Choice Elements
  • ETO Results | Formula: Combine or Concatenate Data
  • ETO Results | Formulas: Display Value for Null Values
  • ETO Results | Retrieve Month, Day, or Year from Date Object
  • ETO Results | Formula: Display Date Prompts in Report
  • ETO Results | Hyperlinks to ETO Pages
  • ETO Results | Common Functions and Operators
  • ETO Results | Functions: Floor and Ceil
  • ETO Results | Formula: Format Phone Number
  • ETO Results | Calculate Start/End Time Duration in TouchPoint Responses
  • ETO Results | Formula: Most Recent Response to a TouchPoint
  • ETO Results | Manually Flatten Demographics or TouchPoint Responses
  • ETO Results | Functions: FormatDate
  • ETO Results | Create a Flag
  • ETO Results | Formula: Format Social Security Number
  • ETO Results | Functions: Min, Max, First, Last
  • Next ›
  • Last »
Bonterra