All functions (A-Z)
Overview
This page is the complete alphabetical index of all functions available in node formulas. Use it to find a function quickly and open the individual function page for syntax, parameters, and examples.
How to use this page
Search the Function column (Ctrl/Cmd+F) to jump to a function name.
Use Category to confirm you’re in the right function family.
A–Z index
Function names link to the full function page.
Function | Category | Description |
|---|---|---|
Math & numeric | Returns the absolute value of each value in the node. | |
Math & numeric | Adds the specified amount to each row in the node without aggregation. | |
Arithmetic operators | Adds up nodes by rolling them up to the same set of levels (intersect). | |
Logical functions | Returns 1 (true) if both inputs are true; otherwise 0 (false). | |
Data access | Calls an external application with an HTTP POST request to a specified URL and returns the result to the model. | |
Rollforward & time series | Forecasts values using an autoregressive integrated moving average (ARIMA) model. | |
Assumptions & result sets | Returns the value of a node with no assumptions applied on the node or anywhere upstream. | |
Compare periods | Calculates the compound annual growth rate over a specified number of periods. | |
Data access | References a DataTable directly and returns its values. | |
Compare periods | Calculates the absolute difference between consecutive values within the selected dimension. | |
Compare periods | Calculates the relative difference between consecutive values within the selected dimension. | |
Finance functions | Calculates straight-line depreciation per period from initial value and depreciation time. | |
Assumptions & result sets | Distributes values of one node onto a level based on another node’s value distribution (legacy; use DISTRIBUTE). | |
Dimensionality & hierarchies | Distributes values of one node across levels based on another node’s value distribution. | |
Math & numeric | Divides the first input by the second with optional validation that provides detailed errors on mismatches. | |
Arithmetic operators | Divides nodes by performing a join along the shared levels of the nodes (dimension union). | |
Dimensionality & hierarchies | Removes one or more levels (and any finer levels in the same dimension) from the node. | |
Filtering & data shaping | Numbers rows in ascending or descending order by value magnitude. | |
Filtering & data shaping | Numbers level values ascending or descending in the order defined in dimension management. | |
Logical functions | Returns 1 (true) if matching row values across two nodes are equal; otherwise 0 (false). | |
Math & numeric | Calculates e (≈2.718) raised to the power of the input values. | |
Dimensionality & hierarchies | Expands a node or a specified value by adding the full cross product of the specified levels. | |
Dimensionality & hierarchies | Expands a node or a value to the specified level values. | |
Math & numeric | Returns the factorial of each input value. | |
Logical functions | Returns 0 (false) for every defined value in the node. | |
Filtering & data shaping | Fills missing level values for a dimension into the node’s data. | |
Filtering & data shaping | Fills missing level values for a dimension with the last available value in the node. | |
Filtering & data shaping | Fills missing (NA) values for existing level combinations after pivoting a dimension into columns. | |
Filtering & data shaping | Filters the node to rows where the specified level satisfies the filter operation. | |
Filtering & data shaping | Returns the first value per group defined by the specified level. | |
Filtering & data shaping | Marks missing level values between two nodes as 1 and existing ones as 0. | |
Finance functions | Calculates the future value of a recurring annuity given interest rate, periods, and payments. | |
Logical functions | Returns 1 (true) where the first input is greater than the second. | |
Logical functions | Returns 1 (true) where the first input is greater than or equal to the second. | |
Logical functions | Returns value_if_true when a condition is true; otherwise returns value_if_false. | |
Finance functions | Calculates the internal rate of return. | |
Logical functions | Returns 1 (true) where values are undefined in the input node’s dimensionality; otherwise 0. | |
Filtering & data shaping | Filters the node to rows where a comparison between two level values meets a specified condition. | |
Math & numeric | Returns the natural logarithm of the input. | |
Math & numeric | Returns the logarithm of a value with respect to a specified base. | |
Filtering & data shaping | Looks up a value in an index table and returns the corresponding value from a return table using threshold (approximate) matching. | |
Logical functions | Returns 1 (true) where the first node’s values are less than the second. | |
Logical functions | Returns 1 (true) where the first node’s values are less than or equal to the second. | |
Math & numeric | Returns the row-wise maximum of two nodes. | |
Math & numeric | Returns the row-wise minimum of two nodes. | |
Math & numeric | Returns the remainder after dividing the first input by the second. | |
Compare periods | Returns absolute month-over-month growth compared to the previous month. | |
Compare periods | Returns relative month-over-month growth compared to the previous month. | |
Rollforward & time series | Returns the moving average of the current value and preceding values, as defined by a time window. | |
Rollforward & time series | Returns the moving sum of the current value and preceding values, as defined by a time window. | |
MTD (see YTD) | Rollforward & time series | Returns month-to-date values as a running sum per month over the lowest time level. |
Math & numeric | Multiplies inputs with optional validation that provides detailed errors on mismatches. | |
Arithmetic operators | Multiplies nodes by performing a join along the shared levels of the nodes (dimension union). | |
Logical functions | Returns 1 (true) where matching values of two nodes are not equal. | |
Assumptions & result sets | Returns a node’s value without assumptions on the node itself while applying assumptions upstream. | |
Logical functions | Inverts logical values (non-zero becomes 0; zero becomes 1). | |
Finance functions | Calculates the number of periods for an investment given rate, payment, and present value. | |
Finance functions | Calculates net present value from a discount rate and a series of cash flows. | |
Logical functions | Returns 1 (true) if at least one of the two inputs is true; otherwise 0 (false). | |
Compare periods | Returns the values for the previous month. | |
Finance functions | Calculates the periodic payment for an investment given rate, periods, and present value. | |
Math & numeric | Raises values from the first node to exponents from the second input. | |
Compare periods | Returns the values for the previous quarter. | |
Rollforward & time series | Returns the previous period’s value, except at a base period where it takes a specified base node value, enabling loop calculations. | |
Finance functions | Calculates present value given rate, periods, payments, and future value/type. | |
Compare periods | Returns the values for the previous week. | |
Compare periods | Returns the values for the previous year. | |
Compare periods | Returns absolute quarter-over-quarter growth compared to the previous quarter. | |
Compare periods | Returns relative quarter-over-quarter growth compared to the previous quarter. | |
QTD (see YTD) | Rollforward & time series | Returns quarter-to-date values as a running sum per quarter over the lowest time level. |
Finance functions | Solves for the interest rate per period of an annuity given periods, payments, present value, and optional parameters. | |
Math & numeric | Divides the first node by the second while retaining only joint dimensions (not usable in nodes referenced by other nodes). | |
Dimensionality & hierarchies | Rebooks numeric values from one level value to another within the same level. | |
Dimensionality & hierarchies | Redistributes a value within specified clusters, weighted by a distribution measure. | |
Dimensionality & hierarchies | Aggregates a node to only the specified levels. | |
Dimensionality & hierarchies | Aggregates the first node to match the level dimensionality of the second node. | |
Rollforward & time series | Projects a node into the future including the additive effects of defined driver nodes. | |
Rollforward & time series | Projects a node into the future including the multiplicative effects of defined driver nodes. | |
Rollforward & time series | Projects a node into the future including the effects of defined driver nodes and optional parameters (e.g., seasonal/average projection, aging logic). | |
Math & numeric | Rounds each value to a specified number of decimal digits. | |
Rollforward & time series | Calculates the cumulative product along the time axis. | |
Rollforward & time series | Calculates the cumulative sum along the time axis. | |
Rollforward & time series | Calculates a project KPI (e.g., revenue) over time given each project’s timing. | |
Compare periods | Shifts values along a specified level by a given offset (positive or negative). | |
Math & numeric | Returns the sign of each number: 1 for positive, −1 for negative, 0 for zero. | |
Math & numeric | Returns the square root of each value in the node. | |
Rollforward & time series | Stretches curves along the X-axis by a factor, starting at 0 by default or at an optional X position. | |
Arithmetic operators | Subtracts nodes by rolling them up to the same set of levels (intersect). | |
Rollforward & time series | Applies time-lagged effects at a given time granularity to model delays or growth curves. | |
Logical functions | Returns 1 (true) for every defined value in the node. | |
Assumptions & result sets | Combines the result sets of two or more input nodes. | |
Compare periods | Returns absolute week-over-week growth compared to the previous week. | |
Compare periods | Returns relative week-over-week growth compared to the previous week. | |
WTD (see YTD) | Rollforward & time series | Returns week-to-date values as a running sum per week over the lowest time level. |
Logical functions | Returns 1 (true) if exactly one of two inputs is true (exclusive OR). | |
Compare periods | Returns absolute year-over-year growth compared to the previous year. | |
Compare periods | Returns relative year-over-year growth compared to the previous year. | |
Rollforward & time series | Returns year-to-date values as a running sum per year over the lowest time level. |
Related sections
Function catalog overview for function discovery
Operators arithmetic, comparisons, and boolean logic used inside formulas
Formula basics notation, references, constants, and evaluation fundamentals