This article lists the functions available when writing formulas in the Formula Builder, organized by Formula Mode. For guidance on creating and testing formulas, see Understanding formulas in CORE Insights.
Standardized Syntax Functions
The following functions are available when writing formulas in Standardized Syntax mode. Function names must be entered in uppercase.
| Function Name | Type | Description |
| ABS | Numeric | Returns the absolute (non-negative) value of a number. |
| AND | Logical | Returns true only if every condition evaluates to true. |
| CONCATENATE | String/Text | Combines two or more strings into a single string. |
| DATEADD | Date/Time | Adds a specified amount of time to a date. Supports years, months, days, hours, minutes, and seconds. |
| DATESUBTRACT | Date/Time | Subtracts a specified amount of time from a date. Supports years, months, days, hours, minutes, and seconds. |
| DATEDIF | Date/Time | Calculates the difference between two dates in the specified unit of time. |
| DAY | Date/Time | Returns the day of the month from a date, as a number from 1 to 31. |
| DAYOFWEEK | Date/Time | Returns the day of the week for a given date. |
| EVEN | Numeric | Rounds a number up to the nearest even integer. |
| EXP | Numeric | Returns Euler's number (e) raised to the power of a given number. |
| HOUR | Date/Time | Returns the hour portion of a datetime value, as a number from 0 to 23. |
| IF | Logical | Evaluates a condition and returns one value if true and another if false. |
| IFS | Logical | Evaluates multiple conditions in order and returns the value for the first one that is true. |
| INCLUDE | String/Text | Returns true if a string contains a specific set of characters. Case sensitive. |
| ISNULL | Logical | Substitutes a specified value in place of a null value. |
| LEFT | String/Text | Returns a set number of characters from the beginning of a string. |
| LENGTH | String/Text | Returns the number of characters in a string. |
| LOG | Numeric | Returns the logarithm of a number using a specified base. |
| LOWER | String/Text | Converts all characters in a string to lowercase. |
| MAX | Numeric | Returns the largest of two or more numeric or date values. |
| MID | String/Text | Returns a specific number of characters from a string, starting at a specified position. |
| MILLISECOND | Date/Time | Returns the millisecond portion of a datetime value, as a number from 0 to 999. |
| MIN | Numeric | Returns the smallest of two or more numeric or date values. |
| MINUTE | Date/Time | Returns the minute portion of a datetime value, as a number from 0 to 59. |
| MONTH | Date/Time | Returns the month of a date, as a number from 1 (January) to 12 (December). |
| NOW | Date/Time | Returns the current date and time at the moment the formula runs. |
| ODD | Numeric | Rounds a number up to the nearest odd integer. |
| OR | Logical | Returns true if at least one condition evaluates to true. |
| POWER | Numeric | Raises a number to the power of a second number. |
| PROPER | String/Text | Capitalizes the first letter of each word in a string and converts the rest to lowercase. |
| RANDOM | Numeric | Returns a random decimal value between 0 (inclusive) and 1 (exclusive). |
| REPLACE | String/Text | Replaces a specific sequence of characters in a string with another sequence. Case sensitive. |
| RIGHT | String/Text | Returns a set number of characters from the end of a string. |
| ROUND | Numeric | Rounds a number to a specified number of decimal places. |
| ROUNDDOWN | Numeric | Rounds a number down to a specified number of decimal places. |
| ROUNDUP | Numeric | Rounds a number up to a specified number of decimal places. |
| SECOND | Date/Time | Returns the second portion of a datetime value, as a number from 0 to 59. |
| SQRT | Numeric | Returns the positive square root of a number. |
| TEXT | String/Text | Converts a number into a text string. |
| TRIM | String/Text | Removes leading and trailing spaces from a string. |
| UPPER | String/Text | Converts all characters in a string to uppercase. |
| YEAR | Date/Time | Returns the year of a date, as a four digit number. |
Aggregate Functions (Standardized Syntax)
The following aggregate functions are available only in Standardized Syntax mode, as described in Understanding formulas in CORE Insights.
| Function Name | Type | Description |
| AVG | Numeric | Returns the average value across a group. |
| COUNT | Numeric | Returns the number of records in each group. |
| DISTCOUNT | Numeric | Returns the number of distinct values in a column across a group. |
| MAXVAL | Numeric | Returns the highest value in a column across a group. |
| MINVAL | Numeric | Returns the lowest value in a column across a group. |
| SUM | Numeric | Returns the total of all values in a column across a group. |
| MED | Numeric | Returns the median value in a column across a group. |
Data Engine Syntax Functions
Data Engine Syntax mode uses lowercase functions based on the connected database's own function set, including a defined set of date functions:
- now
- dateFormat
- dateParse
- dateAdd
- dateSubtract
- dateDiff
- dateIsNull
Note: Data Engine Syntax also supports the broader numeric and text function sets of the underlying data engine, which are not itemized here.