Formulas in Aire Labs
Formulas are expressions that compute the value of a term from other terms, constants, and built-in functions. They support standard arithmetic, arrays, units, financial calculations, and time-series logic.Writing Formulas
Basic Syntax
Operators
Comparison and logical operators return
1 (true) or 0 (false).
Referencing Other Terms
Refer to other terms by their name. Aire Labs resolves references from right to left. You can use a term’s full name or any unique suffix:#ambiguous error. Use a longer suffix to disambiguate.
Constants
Built-in Functions
Function names are not case-sensitive. Every numeric function carries units through its result, soSUM of values in MWh returns MWh. The formula editor suggests every function as you type, with its arguments.
Financial
Financial
Math
Math
Aggregation & Statistics
Aggregation & Statistics
Arrays
Arrays
Lookup
Lookup
Logic & Conditions
Logic & Conditions
Dates
Dates
Time Series
Time Series
Text
Text
Units
Units
See Units for all supported unit strings.
Model Structure
Model Structure
Solvers
Solvers
The Formula Editor
The formula editor is where you write and edit formulas for any calculated term. It’s available throughout Aire. Open it from the term detail panel, from any block view, or directly from a cell in Project Model. You can also describe the calculation to Aire AI, which writes the formula and validates it before saving. Grid Mode adds one particularly useful entry point: clicking a calculated term opens the editor inline without navigating away from your model, so you can edit formulas while keeping your place in the spreadsheet. See Project Model for the full layout options.Authoring
- Enter to insert: Pressing Enter on any value or formula line inserts a new line directly below.
- Line numbers: Line numbers are visible in the editor for easier navigation in longer formulas.
- Inline computed values: Computed values display inline next to the formula that produced them.
- Human-readable display names: Formulas show display names for referenced terms; hover to reveal the underlying identifier.
- Go to a referenced term: Jump from a reference in the formula to the term it points at.
- Click a value to insert it: While the editor is open, clicking another term’s value in Project Model inserts that term into the formula.
