Function catalog

Overview

The function catalog is the authoritative list of all functions you can use in node formulas. Functions work with multi-dimensional data, so you can combine them with operators and nest them to express more complex logic.

Use this section to look up a function’s purpose, syntax, parameters, and examples. Operators (+ - * / and comparisons) are explained in more detail in Operators.

Start here if…

• You know the name → go to All functions (A-Z)

• You know the problem you want to solve → go to Browse by category

What you’ll find in this section

All functions (A–Z)

A complete index for quick lookup by function name.

Browse by category

Functions grouped by what they help you do:

• Data access: bring uploaded/source data into formulas

• Math & numeric: calculate and transform numeric values

• Logical functions: build conditions and branching

• Filtering & data shaping: filter, pick, rank, or fill missing data

• Dimensionality & hierarchies: reshape results across dimensions and levels

• Rollforward & time series: projections, running totals and moving windows

• Compare periods: time shifting and time-based comparisons

• Finance functions: financial calculations such as NPV, IRR, depreciation

• Assumptions & result sets: control assumption effects and combine result sets

Related sections

• Formula basics notation, quoting rules, constants, comments

• Operators arithmetic and comparisons used inside formulas

• Troubleshooting guide dimensionality and missing value behavior