All functions (A-Z)
This page is the complete alphabetical index of all functions available in node formulas.
Use it to find a function quickly and open the corresponding 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 |
|---|---|---|
| ABS | Math & numeric | Returns the absolute value of each value in the node. |
| ADDEACH | Math & numeric | Adds the specified amount to each row in the node without aggregation. |
| ADDITION (+) | Arithmetic operators | Adds up nodes by rolling them up to the same set of levels (intersect). |
| AND (&&) | Logical functions | Returns 1 (true) if both inputs are true; otherwise 0 (false). |
| API_CALL | Data access | Calls an external application with an HTTP POST request to a specified URL and returns the result to the model. |
| ARIMA | Rollforward & time series | Forecasts values using an autoregressive integrated moving average (ARIMA) model. |
| BASELINE | Assumptions & result sets | Returns the value of a node with no assumptions applied on the node or anywhere upstream. |
| CAGR | Compare periods | Calculates the compound annual growth rate over a specified number of periods. |
| DATA | Data access | References a DataTable directly and returns its values. |
| DELTA_ABS | Compare periods | Calculates the absolute difference between consecutive values within the selected dimension. |
| DELTA_REL | Compare periods | Calculates the relative difference between consecutive values within the selected dimension. |
| DEPRECIATION | Finance functions | Calculates straight-line depreciation per period from initial value and depreciation time. |
| DISAGGREGATE | Assumptions & result sets | Distributes values of one node onto a level based on another node’s value distribution (legacy; use DISTRIBUTE). |
| DISTRIBUTE | Dimensionality & hierarchies | Distributes values of one node across levels based on another node’s value distribution. |
| DIVIDE | Math & numeric | Divides the first input by the second with optional validation that provides detailed errors on mismatches. |
| DIVISION (/) | Arithmetic operators | Divides nodes by performing a join along the shared levels of the nodes (dimension union). |
| DROPLEVEL | Dimensionality & hierarchies | Removes one or more levels (and any finer levels in the same dimension) from the node. |
| ENUM | Filtering & data shaping | Numbers rows in ascending or descending order by value magnitude. |
| ENUM_LEVEL | Filtering & data shaping | Numbers level values ascending or descending in the order defined in dimension management. |
| EQ (=) | Logical functions | Returns 1 (true) if matching row values across two nodes are equal; otherwise 0 (false). |
| EXP | Math & numeric | Calculates e (≈2.718) raised to the power of the input values. |
| EXPAND | Dimensionality & hierarchies | Expands a node or a specified value by adding the full cross product of the specified levels. |
| EXPANDSINGLE | Dimensionality & hierarchies | Expands a node or a value to the specified level values. |
| FACT | Math & numeric | Returns the factorial of each input value. |
| FALSE | Logical functions | Returns 0 (false) for every defined value in the node. |
| FILLMISSING | Filtering & data shaping | Fills missing level values for a dimension into the node’s data. |
| FILLMISSING_LAST | Filtering & data shaping | Fills missing level values for a dimension with the last available value in the node. |
| FILL_NA | Filtering & data shaping | Fills missing (NA) values for existing level combinations after pivoting a dimension into columns. |
| FILTER | Filtering & data shaping | Filters the node to rows where the specified level satisfies the filter operation. |
| FINDFIRST | Filtering & data shaping | Returns the first value per group defined by the specified level. |
| FINDMISSING | Filtering & data shaping | Marks missing level values between two nodes as 1 and existing ones as 0. |
| FV | Finance functions | Calculates the future value of a recurring annuity given interest rate, periods, and payments. |
| GT (>) | Logical functions | Returns 1 (true) where the first input is greater than the second. |
| GTE (>=) | Logical functions | Returns 1 (true) where the first input is greater than or equal to the second. |
| IF | Logical functions | Returns value_if_true when a condition is true; otherwise returns value_if_false. |
| IRR | Finance functions | Calculates the internal rate of return. |
| IS_NA | Logical functions | Returns 1 (true) where values are undefined in the input node’s dimensionality; otherwise 0. |
| LEVELFILTER | Filtering & data shaping | Filters the node to rows where a comparison between two level values meets a specified condition. |
| LN | Math & numeric | Returns the natural logarithm of the input. |
| LOG | Math & numeric | Returns the logarithm of a value with respect to a specified base. |
| LOOKUP | Filtering & data shaping | Looks up a value in an index table and returns the corresponding value from a return table using threshold (approximate) matching. |
| LT (<) | Logical functions | Returns 1 (true) where the first node’s values are less than the second. |
| LTE (<=) | Logical functions | Returns 1 (true) where the first node’s values are less than or equal to the second. |
| MAX | Math & numeric | Returns the row-wise maximum of two nodes. |
| MIN | Math & numeric | Returns the row-wise minimum of two nodes. |
| MOD | Math & numeric | Returns the remainder after dividing the first input by the second. |
| MOM_ABS | Compare periods | Returns absolute month-over-month growth compared to the previous month. |
| MOM_REL | Compare periods | Returns relative month-over-month growth compared to the previous month. |
| MOVINGAVG | Rollforward & time series | Returns the moving average of the current value and preceding values, as defined by a time window. |
| MOVINGSUM | 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. |
| MULTIPLY | Math & numeric | Multiplies inputs with optional validation that provides detailed errors on mismatches. |
| MULTIPLICATION (*) | Arithmetic operators | Multiplies nodes by performing a join along the shared levels of the nodes (dimension union). |
| NEQ (!=) | Logical functions | Returns 1 (true) where matching values of two nodes are not equal. |
| NONSIM | Assumptions & result sets | Returns a node’s value without assumptions on the node itself while applying assumptions upstream. |
| NOT | Logical functions | Inverts logical values (non-zero becomes 0; zero becomes 1). |
| NPER | Finance functions | Calculates the number of periods for an investment given rate, payment, and present value. |
| NPV | Finance functions | Calculates net present value from a discount rate and a series of cash flows. |
| [OR ( | )](/modeling/functions-formulas/function-catalog/all-functions-a-z/or/) | |
| PM | Compare periods | Returns the values for the previous month. |
| PMT | Finance functions | Calculates the periodic payment for an investment given rate, periods, and present value. |
| POWER | Math & numeric | Raises values from the first node to exponents from the second input. |
| PQ | Compare periods | Returns the values for the previous quarter. |
| PREVIOUS | 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. |
| PV | Finance functions | Calculates present value given rate, periods, payments, and future value/type. |
| PW | Compare periods | Returns the values for the previous week. |
| PY | Compare periods | Returns the values for the previous year. |
| QOQ_ABS | Compare periods | Returns absolute quarter-over-quarter growth compared to the previous quarter. |
| QOQ_REL | 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. |
| RATE | Finance functions | Solves for the interest rate per period of an annuity given periods, payments, present value, and optional parameters. |
| RATIO | Math & numeric | Divides the first node by the second while retaining only joint dimensions. Must be an end node, the result cannot be used in further calculations. |
| REBOOK | Dimensionality & hierarchies | Rebooks numeric values from one level value to another within the same level. |
| REDISTRIBUTE | Dimensionality & hierarchies | Redistributes a value within specified clusters, weighted by a distribution measure. |
| ROLLUP | Dimensionality & hierarchies | Aggregates a node to only the specified levels. |
| ROLLUP_TO | Dimensionality & hierarchies | Aggregates the first node to match the level dimensionality of the second node. |
| ROLLFORWARD | Rollforward & time series | Projects a node into the future including the additive effects of defined driver nodes. |
| ROLLFORWARD_MUL | Rollforward & time series | Projects a node into the future including the multiplicative effects of defined driver nodes. |
| ROLLFORWARD_ADVANCED | 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). |
| ROUND | Math & numeric | Rounds each value to a specified number of decimal digits. |
| RUNNINGPROD | Rollforward & time series | Calculates the cumulative product along the time axis. |
| RUNNINGSUM | Rollforward & time series | Calculates the cumulative sum along the time axis. |
| SCHEDULEPROJECTS | Rollforward & time series | Calculates a project KPI (e.g., revenue) over time given each project’s timing. |
| SHIFT | Compare periods | Shifts values along a specified level by a given offset (positive or negative). |
| SIGNUM | Math & numeric | Returns the sign of each number: 1 for positive, −1 for negative, 0 for zero. |
| SQRT | Math & numeric | Returns the square root of each value in the node. |
| STRETCH_CURVE | Rollforward & time series | Stretches curves along the X-axis by a factor, starting at 0 by default or at an optional X position. |
| SUBTRACTION (-) | Arithmetic operators | Subtracts nodes by rolling them up to the same set of levels (intersect). |
| TIMELAG | Rollforward & time series | Applies time-lagged effects at a given time granularity to model delays or growth curves. |
| TRUE | Logical functions | Returns 1 (true) for every defined value in the node. |
| UNION | Assumptions & result sets | Combines the result sets of two or more input nodes. |
| WOW_ABS | Compare periods | Returns absolute week-over-week growth compared to the previous week. |
| WOW_REL | 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. |
| XOR | Logical functions | Returns 1 (true) if exactly one of two inputs is true (exclusive OR). |
| YOY_ABS | Compare periods | Returns absolute year-over-year growth compared to the previous year. |
| YOY_REL | Compare periods | Returns relative year-over-year growth compared to the previous year. |
| YTD | Rollforward & time series | Returns year-to-date values as a running sum per year over the lowest time level. |
Related sections
- Browse by category: find functions by modeling goal
- Operators: arithmetic, comparisons, and boolean logic used inside formulas
- Formula basics: notation, references, constants, and evaluation fundamentals