Functions

Definition

Functions perform a task on the data fed into it, usually producing some sort of data or output. The data fed into a function can be anything, from plaid text to numbers and dates to objects from the report. The results are entirely dependent on what the function has been programmed to do. The most popular functions and function types are described in this section.

Important Concepts

"True" and "False": Some functions simply test whether a piece of data fits a particular condition. This kind of function returns only two values: true, represented by a 1, and false, represented by a 0.

Popular Functions Guides

• Aggregate Functions
  • Compare and compile information from multiple rows to determine a single value
  • E.g. Count, Sum, Max, Min
• Character Functions
  • Parse and format text
  • E.g. Left, Right, Pos, Length
• Date and Time Functions
  • Derive or calculate information from dates
  • CurrentDate, LastDayOfMonth, DaysBetween
• Other Functions
  • Logical functions such as Even, Odd, IsNull
  • Document functions such as DocumentAuthor, DocumentName
• Conditional Function: If-Then
  • Covered in Formula Basics