The following formula functions are currently supported in Chains and Data Prep pipeline transformations. Please note that the functions listed here are separate from those used elsewhere in Workiva.
| Function | Description |
|---|---|
| ABS | Returns the absolute value of a number. |
| ACOS | Returns the arccosine of a number. |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ADDRESS | Returns a reference as text to a single cell in a worksheet |
| AND | Returns TRUE if all arguments evaluate to TRUE. |
| AREAS | Returns the number of areas in a reference. |
| ASIN | Returns the arcsine of a number. |
| ASINH | Returns the inverse hyperbolic sine of a number. |
| ATAN | Returns the arctangent of a number. |
| ATAN2 | Returns the arctangent from x- and y-coordinates. |
| ATANH | Returns the inverse hyperbolic tangent of a number. |
| AVEDEV | Returns the average of the absolute deviations from the mean. |
| AVERAGE | Returns the average of its arguments |
| AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values. |
| CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance. |
| CHAR | Returns the character associated with the given character code |
| CHOOSE | Returns a value from a list. |
| CLEAN | Removes non-printable characters from text. |
| CODE | Returns the numeric code for the first character in text. |
| COLUMN | Returns the column number of a reference. |
| COLUMNS | Returns the number of columns in a reference. |
| COMBIN | Calculates the number of combinations for a given number of items. |
| CONCATENATE | Joins multiple text strings into one. |
| CORREL | Returns the correlation coefficient between two datasets. |
| COS | Returns the cosine of an angle. |
| COSH | Returns the hyperbolic cosine of a number. |
| COUNT | Counts numeric values in a range. |
| COUNTA | Counts non-blank cells in a range. |
| COUNTBLANK | Counts the number of blank cells in a range. |
| COUNTIF | Counts cells that meet a specified condition. |
| COVAR | Calculates covariance, a measure of the relationship between two datasets. |
| DAVERAGE | Returns the average of selected database entries. |
| DATE | Returns a date from a given year, month, and day. |
| DATEVALUE | Returns a serial number based on a date written in MM/DD/YYYY format. |
| DAYS360 | Calculates the number of days between dates using a 360-day year. |
| DCOUNT | Counts numeric values in a database. |
| DCOUNTA | Counts non-blank cells in a database. |
| DEGREES | Converts radians to degrees. |
| DEVSQ | Returns the sum of squares of deviation. |
| DGET | Extracts from a database a single record that matches the specified criteria. |
| DMAX | Returns the maximum value from selected database entries. |
| DMIN | Returns the minimum value from selected database entries. |
| DOLLAR | Formats a number as text in currency format. |
| DPRODUCT | Multiplies the values in a particular field of records that match the criteria in a database. |
| DSTDEV | Estimates standard deviation from a sample of a database. |
| DSTDEVP | Calculates standard deviation for an entire database population. |
| DSUM | Adds the numbers in the field column of records in the database that match the criteria. |
| DVAR | Estimates variance from a sample of a database. |
| DVARP | Calculates variance for an entire database population. |
| ERROR.TYPE | Returns a number corresponding to an error type. |
| EVEN | Rounds a number up to the nearest even integer. |
| EXACT | Checks if two text strings are exactly the same. |
| EXP | Returns e raised to the power of a number. |
| FACT | Returns the factorial of a number. |
| FALSE | Returns the logical value FALSE. |
| FIND | Returns the starting position of a text string within another. |
| FIXED | Rounds a number to a specified number of decimals as text. |
| FLOOR | Rounds a number down to the nearest multiple of a specified value. |
| FORECAST | Returns a value along a linear trend. |
| FREQUENCY | Returns a frequency distribution as a vertical array. |
| FV | Returns the future value of an investment. |
| GEOMEAN | Returns the geometric mean of a range. |
| HLOOKUP | Looks in the top row of an array and returns the value of the indicated cell. |
| HOUR | Returns the hour of a time value. |
| HYPERLINK | Creates a clickable link. |
| IF | Performs a logical test and returns one value for TRUE and another for FALSE. |
| INDEX | Returns the value of a cell within a range based on row and column numbers. |
| INDIRECT | Returns the reference specified by a text string. |
| INT | Rounds a number down to the nearest integer. |
| INTERCEPT | Returns the intercept of the linear regression line. |
| IPMT | Returns the interest payment for a given period of an investment. |
| IRR | Calculates the internal rate of return for an investment. |
| ISBLANK | Returns TRUE if a cell is empty. |
| ISERR | Returns TRUE if a value is any error except #N/A. |
| ISERROR | Returns TRUE if a value is any error. |
| ISLOGICAL | Returns TRUE if a value is a logical value (TRUE or FALSE). |
| ISNA | Returns TRUE if a value is the #N/A error. |
| ISNONTEXT | Returns TRUE if a value is not text. |
| ISNUMBER | Returns TRUE if a value is a number. |
| ISREF | Returns TRUE if a value is a reference. |
| ISTEXT | Returns TRUE if a value is text. |
| LARGE | Returns the n-th largest value from a range. |
| LEFT | Returns the first characters in a text string, based on the specified number. |
| LEN | Returns the number of characters in a text string. |
| LN | Returns the natural logarithm of a number. |
| LOG | Returns the logarithm of a number to a specified base. |
| LOG10 | Returns the base-10 logarithm of a number. |
| LOOKUP | Searches for a value in a range and returns a corresponding value. |
| LOWER | Converts text to lowercase. |
| MATCH | Returns the relative position of a value in a range. |
| MAX | Returns the largest value in a range. |
| MAXA | Returns the largest value in a range, including text and logical values. |
| MDETERM | Returns the matrix determinant of an array. |
| MEDIAN | Returns the median of a set of numbers. |
| MID | Returns a specific number of characters from text, starting at a given position. |
| MIN | Returns the smallest value in a range. |
| MINA | Returns the smallest value in a range, including text and logical values. |
| MINUTE | Returns the minute of a time value. |
| MINVERSE | Returns the matrix inverse of an array. |
| MIRR | Returns the modified internal rate of return for an investment. |
| MMULT | Returns the matrix product of two arrays. |
| MOD | Returns the remainder after division. |
| MONTH | Returns the month of a date. |
| NA | Returns the #N/A error value. |
| NORMDIST | Returns the normal cumulative distribution for a specified mean and standard deviation. |
| NORMINV | Returns the inverse of the normal cumulative distribution. |
| NORMSDIST | Returns the standard normal cumulative distribution. |
| NORMSINV | Returns the inverse of the standard normal cumulative distribution. |
| NOT | Reverses the logical value of its argument. |
| NOW | Returns the current date and time. |
| NPER | Returns the number of periods for an investment. |
| NPV | Calculates the net present value of an investment. |
| ODD | Rounds a number up to the nearest odd integer. |
| OFFSET | Returns a reference offset from a starting point. |
| OR | Returns TRUE if any arguments evaluate to TRUE. |
| PI | Returns the value of π (pi). |
| POISSON | Returns the Poisson distribution. |
| POWER | Returns a number raised to a power. |
| PPMT | Returns the payment on the principal for a given period. |
| PRODUCT | Multiplies all numbers in a range. |
| PROPER | Capitalizes the first letter of each word in a text string. |
| PV | Calculates the present value of an investment. |
| RADIANS | Converts degrees to radians. |
| RAND | Returns a random number between 0 and 1. |
| RATE | Returns the interest rate per period of an investment. |
| REPLACE | Replaces part of a text string with another. |
| REPT | Repeats text a specified number of times. |
| RIGHT | Returns the last characters in a text string, based on the specified number. |
| ROUND | Rounds a number to a specified number of digits. |
| ROUNDDOWN | Rounds a number down to the nearest integer. |
| ROUNDUP | Rounds a number up to the nearest integer. |
| ROW | Returns the row number of a reference. |
| ROWS | Returns the number of rows in a reference. |
| SEARCH | Finds a text string within another and returns its position. |
| SIGN | Returns the sign of a number: 1 for positive, -1 for negative, 0 for zero. |
| SIN | Returns the sine of an angle. |
| SINH | Returns the hyperbolic sine of a number. |
| SLOPE | Returns the slope of a linear regression line. |
| SMALL | Returns the k-th smallest value in a dataset. |
| SQRT | Returns the square root of a number. |
| STDEV | Estimates standard deviation based on a sample. |
| STDEVA | Estimates standard deviation including text and logical values. |
| STDEVP | Calculates standard deviation for an entire population. |
| STDEVPA | Calculates standard deviation for an entire population, including text and logical values. |
| STEYX | Returns the standard error of the predicted y value for each x in a regression. |
| SUBSTITUTE | Replaces occurrences of a text string with another. |
| SUBTOTAL | Returns a subtotal for a list or database. |
| SUM | Adds all numbers in a range. |
| SUMIF | Adds numbers that meet a specified condition. |
| SUMPRODUCT | Returns the sum of the products of corresponding array elements. |
| SUMSQ | Returns the sum of the squares of numbers. |
| SUMX2MY2 | Returns the sum of the differences of squares. |
| SUMX2PY2 | Returns the sum of the sums of squares. |
| SUMXMY2 | Returns the sum of squared differences. |
| T | Converts its arguments to text. |
| TEXT | Formats a value and converts it to text. |
| TIME | Returns a time value from hour, minute, and second. |
| TIMEVALUE | Converts a time in text format to a serial number. |
| TODAY | Returns the current date. |
| TRANSPOSE | Returns the transpose of an array. |
| TREND | Returns values along a linear trend. |
| TRIM | Removes extra spaces from text. |
| TRUE | Returns the logical value TRUE. |
| TRUNC | Truncates a number to an integer by removing the fractional part. |
| UPPER | Converts text to uppercase. |
| VALUE | Converts text to a numeric value. |
| VAR | Estimates variance based on a sample. |
| VARA | Estimates variance including text and logical values. |
| VARP | Calculates variance for an entire population. |
| VARPA | Calculates variance for an entire population, including text and logical values. |
| VDB | Returns the depreciation of an asset for a specified or partial period by using a declining balance method |
| VLOOKUP | Looks in the first column of an array and moves across the row to return the value of a cell. |
| WEEKDAY | Returns the day of the week as a number. |
| WEEKNUM | Returns the week number of a date. |
| WORKDAY | Returns a workday after a specified number of days. |
| YEAR | Returns the year of a date. |
| YEARFRAC | Returns the year fraction representing the number of whole days between start_date and end_date. |