# All functions (A-Z) URL: https://docs.valsight.ai/all-functions-a-z/ Description: This page is the complete alphabetical index of all functions available in node formulas. 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](/abs/) | Math & numeric | Returns the absolute value of each value in the node. | | [ADDEACH](/addeach/) | Math & numeric | Adds the specified amount to each row in the node without aggregation. | | [ADDITION (+)](/addition/) | Arithmetic operators | Adds up nodes by rolling them up to the same set of levels (intersect). | | [AND (&&)](/and/) | Logical functions | Returns 1 (true) if both inputs are true; otherwise 0 (false). | | [API\_CALL](/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](/arima/) | Rollforward & time series | Forecasts values using an autoregressive integrated moving average (ARIMA) model. | | [BASELINE](/baseline/) | Assumptions & result sets | Returns the value of a node with no assumptions applied on the node or anywhere upstream. | | [CAGR](/cagr/) | Compare periods | Calculates the compound annual growth rate over a specified number of periods. | | [DATA](/data/) | Data access | References a data table directly and returns its values. | | [DELTA\_ABS](/delta-abs/) | Compare periods | Calculates the absolute difference between consecutive values within the selected dimension. | | [DELTA\_REL](/delta-rel/) | Compare periods | Calculates the relative difference between consecutive values within the selected dimension. | | [DEPRECIATION](/depreciation/) | Finance functions | Calculates straight-line depreciation per period from initial value and depreciation time. | | [DISAGGREGATE](/disaggregate/) | Assumptions & result sets | Distributes values of one node onto a level based on another node’s value distribution (legacy; use DISTRIBUTE). | | [DISTRIBUTE](/distribute/) | Dimensionality & hierarchies | Distributes values of one node across levels based on another node’s value distribution. | | [DIVIDE](/divide/) | Math & numeric | Divides the first input by the second with optional validation that provides detailed errors on mismatches. | | [DIVISION (/)](/division/) | Arithmetic operators | Divides nodes by performing a join along the shared levels of the nodes (dimension union). | | [DROPLEVEL](/droplevel/) | Dimensionality & hierarchies | Removes one or more levels (and any finer levels in the same dimension) from the node. | | [ENUM](/enum/) | Filtering & data shaping | Numbers rows in ascending or descending order by value magnitude. | | [ENUM\_LEVEL](/enum-level/) | Filtering & data shaping | Numbers level values ascending or descending in the order defined in dimension management. | | [EQ (=)](/eq/) | Logical functions | Returns 1 (true) if matching row values across two nodes are equal; otherwise 0 (false). | | [EXP](/exp/) | Math & numeric | Calculates *e* (≈2.718) raised to the power of the input values. | | [EXPAND](/expand/) | Dimensionality & hierarchies | Expands a node or a specified value by adding the full cross product of the specified levels. | | [EXPANDSINGLE](/expandsingle/) | Dimensionality & hierarchies | Expands a node or a value to the specified level values. | | [FACT](/fact/) | Math & numeric | Returns the factorial of each input value. | | [FALSE](/false/) | Logical functions | Returns 0 (false) for every defined value in the node. | | [FILLMISSING](/fillmissing/) | Filtering & data shaping | Fills missing level values for a dimension into the node’s data. | | [FILLMISSING\_LAST](/fillmissing-last/) | Filtering & data shaping | Fills missing level values for a dimension with the last available value in the node. | | [FILL\_NA](/fill-na/) | Filtering & data shaping | Fills missing (NA) values for existing level combinations after pivoting a dimension into columns. | | [FILTER](/filter/) | Filtering & data shaping | Filters the node to rows where the specified level satisfies the filter operation. | | [FINDFIRST](/findfirst/) | Filtering & data shaping | Returns the first value per group defined by the specified level. | | [FINDMISSING](/findmissing/) | Filtering & data shaping | Marks missing level values between two nodes as 1 and existing ones as 0. | | [FV](/fv/) | Finance functions | Calculates the future value of a recurring annuity given interest rate, periods, and payments. | | [GT (>)](/gt/) | Logical functions | Returns 1 (true) where the first input is greater than the second. | | [GTE (>=)](/gte/) | Logical functions | Returns 1 (true) where the first input is greater than or equal to the second. | | [IF](/if/) | Logical functions | Returns value\_if\_true when a condition is true; otherwise returns value\_if\_false. | | [IRR](/irr/) | Finance functions | Calculates the internal rate of return. | | [IS\_NA](/is-na/) | Logical functions | Returns 1 (true) where values are undefined in the input node’s dimensionality; otherwise 0. | | [LEVELFILTER](/levelfilter/) | Filtering & data shaping | Filters the node to rows where a comparison between two level values meets a specified condition. | | [LN](/ln/) | Math & numeric | Returns the natural logarithm of the input. | | [LOG](/log/) | Math & numeric | Returns the logarithm of a value with respect to a specified base. | | [LOOKUP](/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 (<)](/lt/) | Logical functions | Returns 1 (true) where the first node’s values are less than the second. | | [LTE (<=)](/lte/) | Logical functions | Returns 1 (true) where the first node’s values are less than or equal to the second. | | [MAX](/max/) | Math & numeric | Returns the row-wise maximum of two nodes. | | [MIN](/min/) | Math & numeric | Returns the row-wise minimum of two nodes. | | [MOD](/mod/) | Math & numeric | Returns the remainder after dividing the first input by the second. | | [MOM\_ABS](/mom-abs/) | Compare periods | Returns absolute month-over-month growth compared to the previous month. | | [MOM\_REL](/mom-rel/) | Compare periods | Returns relative month-over-month growth compared to the previous month. | | [MOVINGAVG](/movingavg/) | Rollforward & time series | Returns the moving average of the current value and preceding values, as defined by a time window. | | [MOVINGSUM](/movingsum/) | Rollforward & time series | Returns the moving sum of the current value and preceding values, as defined by a time window. | | **MTD** (see [YTD](/ytd/)) | Rollforward & time series | Returns month-to-date values as a running sum per month over the lowest time level. | | [MULTIPLY](/multiply/) | Math & numeric | Multiplies inputs with optional validation that provides detailed errors on mismatches. | | [MULTIPLICATION (\*)](/multiplication/) | Arithmetic operators | Multiplies nodes by performing a join along the shared levels of the nodes (dimension union). | | [NEQ (!=)](/neq/) | Logical functions | Returns 1 (true) where matching values of two nodes are not equal. | | [NONSIM](/nonsim/) | Assumptions & result sets | Returns a node’s value without assumptions on the node itself while applying assumptions upstream. | | [NOT](/not/) | Logical functions | Inverts logical values (non-zero becomes 0; zero becomes 1). | | [NPER](/nper/) | Finance functions | Calculates the number of periods for an investment given rate, payment, and present value. | | [NPV](/npv/) | Finance functions | Calculates net present value from a discount rate and a series of cash flows. | | [OR (\|\|)](/or/) | Logical functions | Returns 1 (true) if at least one of the two inputs is true; otherwise 0 (false). | | [PM](/pm/) | Compare periods | Returns the values for the previous month. | | [PMT](/pmt/) | Finance functions | Calculates the periodic payment for an investment given rate, periods, and present value. | | [POWER](/power/) | Math & numeric | Raises values from the first node to exponents from the second input. | | [PQ](/pq/) | Compare periods | Returns the values for the previous quarter. | | [PREVIOUS](/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](/pv/) | Finance functions | Calculates present value given rate, periods, payments, and future value/type. | | [PW](/pw/) | Compare periods | Returns the values for the previous week. | | [PY](/py/) | Compare periods | Returns the values for the previous year. | | [QOQ\_ABS](/qoq-abs/) | Compare periods | Returns absolute quarter-over-quarter growth compared to the previous quarter. | | [QOQ\_REL](/qoq-rel/) | Compare periods | Returns relative quarter-over-quarter growth compared to the previous quarter. | | **QTD** (see [YTD](/ytd/)) | Rollforward & time series | Returns quarter-to-date values as a running sum per quarter over the lowest time level. | | [RATE](/rate/) | Finance functions | Solves for the interest rate per period of an annuity given periods, payments, present value, and optional parameters. | | [RATIO](/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](/rebook/) | Dimensionality & hierarchies | Rebooks numeric values from one level value to another within the same level. | | [REDISTRIBUTE](/redistribute/) | Dimensionality & hierarchies | Redistributes a value within specified clusters, weighted by a distribution measure. | | [ROLLFORWARD](/rollforward/) | Rollforward & time series | Projects a node into the future including the additive effects of defined driver nodes. | | [ROLLFORWARD\_ADVANCED](/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). | | [ROLLFORWARD\_MUL](/rollforward-mul/) | Rollforward & time series | Projects a node into the future including the multiplicative effects of defined driver nodes. | | [ROLLUP](/rollup/) | Dimensionality & hierarchies | Aggregates a node to only the specified levels. | | [ROLLUP\_TO](/rollup-to/) | Dimensionality & hierarchies | Aggregates the first node to match the level dimensionality of the second node. | | [ROUND](/round/) | Math & numeric | Rounds each value to a specified number of decimal digits. | | [RUNNINGPROD](/runningprod/) | Rollforward & time series | Calculates the cumulative product along the time axis. | | [RUNNINGSUM](/runningsum/) | Rollforward & time series | Calculates the cumulative sum along the time axis. | | [SCHEDULEPROJECTS](/scheduleprojects/) | Rollforward & time series | Calculates a project KPI (e.g., revenue) over time given each project’s timing. | | [SHIFT](/shift/) | Compare periods | Shifts values along a specified level by a given offset (positive or negative). | | [SIGNUM](/signum/) | Math & numeric | Returns the sign of each number: 1 for positive, −1 for negative, 0 for zero. | | [SQRT](/sqrt/) | Math & numeric | Returns the square root of each value in the node. | | [STRETCH\_CURVE](/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 (-)](/subtraction/) | Arithmetic operators | Subtracts nodes by rolling them up to the same set of levels (intersect). | | [TIMELAG](/timelag/) | Rollforward & time series | Applies time-lagged effects at a given time granularity to model delays or growth curves. | | [TRUE](/true/) | Logical functions | Returns 1 (true) for every defined value in the node. | | [UNION](/union/) | Assumptions & result sets | Combines the result sets of two or more input nodes. | | [WOW\_ABS](/wow-abs/) | Compare periods | Returns absolute week-over-week growth compared to the previous week. | | [WOW\_REL](/wow-rel/) | Compare periods | Returns relative week-over-week growth compared to the previous week. | | **WTD** (see [YTD](/ytd/)) | Rollforward & time series | Returns week-to-date values as a running sum per week over the lowest time level. | | [XOR](/xor/) | Logical functions | Returns 1 (true) if exactly one of two inputs is true (exclusive OR). | | [YOY\_ABS](/yoy-abs/) | Compare periods | Returns absolute year-over-year growth compared to the previous year. | | [YOY\_REL](/yoy-rel/) | Compare periods | Returns relative year-over-year growth compared to the previous year. | | [YTD](/ytd/) | Rollforward & time series | Returns year-to-date values as a running sum per year over the lowest time level. | ## Project variable functions These functions work only in **dynamic project variables**, not in node formulas. See [Project variables](/project-variables/). | Function | Description | | ------------------------------- | ------------------------------------------------------------------------------------------ | | [DATE\_EXTRACT](/date-extract/) | Extracts the year, quarter, month, week, or day from a time level value. | | [DATE\_OFFSET](/date-offset/) | Offsets a time level value forward or backward by years, quarters, months, weeks, or days. | ## Related * [Browse by category](/browse-by-category/): find functions by modeling goal * [Operators](/operators/): arithmetic, comparisons, and boolean logic used inside formulas * [Formula basics](/formula-basics/): notation, references, constants, and evaluation fundamentals