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

How functions & formulas fit into Valsight

Formulas define how node values are calculated. Functions connect data, apply business rules, and shape dimensionality so results can be compared consistently across time and other dimensions.