Quickstart: 10 common functions
This page highlights the functions you’ll use most often when bringing in data, shaping dimensionality, filtering slices, and building time logic.
Use it as a shortcut to common formula patterns before moving to the full Function catalog.
Connect & adjust values
Bring uploaded or source data into a node. Returns the referenced table’s shape.
DATA("Source", "Table", "Measure")
Adjust each value individually, no aggregation. Keeps the input shape.
ADDEACH('Node', Amount)
Time logic & forecasting
Project values forward with forecasting options. Extends the time range.
ROLLFORWARD_ADVANCED('Node', ['Drivers'], ...)
Filter & apply business rules
Return a subset of a node, e.g. specific regions. Reduces to matching rows.
FILTER('Node', "Level", Value)
Apply thresholds, caps, floors, or branching. Follows the condition’s shape.
IF(Condition, ThenValue, ElseValue)
Shape dimensionality
Add dimensional detail. Expands to the cross product of the levels.
EXPAND('Node', "Level", ...)
Expand to specific level values only. Expands only to those values.
EXPANDSINGLE('Node', "Level", Value, ...)
Remove dimensional detail. Drops a level and its finer levels.
DROPLEVEL('Node', "Level", ...)
Aggregate to a higher level, e.g. Month to Year. Reduces to those levels.
ROLLUP('Node', "Level", ...)
Related sections
- Formula basics: syntax, notation, and evaluation fundamentals
- Operators: arithmetic, comparisons, boolean logic used in formulas
- Function catalog: all functions, from A to Z and by category