Functions & Formulas

Overview

This section explains how to write node formulas in the Function Editor: reference node values, combine them with operators, and use functions to calculate across multi-dimensional data.

Use it to learn the core formula conventions and quickly find the right function for your modeling task.

Conventions (TL;DR)

• Node references: use single quotes → 'Revenue'

• Dimensions / levels / level values: use double quotes → "Time", "Year", "2024"

• Lists: use square brackets → ["EMEA", "APAC"]

• Constants: write numbers directly → 0, 1.2 (constants have no dimensions, be explicit if shape matters)

• Comments: start with #

• Functions: written in UPPERCASE (case-sensitive) and can be nested (inner results evaluate first)

Start here if…

• You’re new to formulas → go to Formula basics

• You want to see the most-used functions → go to Quickstart: the 10 functions you’ll use daily

• You want to do a simple calculation or condition → go to Operators

• You know the function name (or want to browse what exists) → go to Function catalog

• Something behaves unexpectedly → go to Troubleshooting guide

What you’ll find in this section

• Formula basics: syntax, notation, and evaluation order

• Quickstart: a shortcut to the 10 functions you’ll use daily

• Operators: arithmetic and conditions in formulas

• Function catalog: function pages with syntax, parameters, and examples

• Troubleshooting guide: diagnose empty results, wrong shape, and wrong numbers

Who this section is for

• Modelers who build or maintain models and need to select or verify formula logic

• Reviewers who want to understand how existing calculations are built

• Teams investigating unexpected results, missing values, or validation warnings