Browse by category
Overview
Browse by category helps you find the right function when you don’t know the exact name yet. Functions are grouped by what they do, so you can start from your modeling goal and drill down to the right reference page.
If you already know the function name, start with All functions (A-Z), it’s faster than browsing by intent.
How to find the right function
Start with the intent, then choose the function group:
Connect uploaded/source data to nodes → Data access
Do a calculation or transform numeric values → Math & numeric
Apply business rules or conditional logic → Logical functions
Filter, pick, rank or fill missing data → Filtering & data shaping
Change the result’s shape or granularity → Dimensionality & hierarchies
Project values forward or build cumulative time logic → Rollforward & time series
Compare values across time → Compare periods
Use finance-specific methods → Finance functions
Control assumption effects or combine results → Assumptions & result sets
Related sections
Function catalog hub for A–Z and category navigation
Operators arithmetic and comparisons used inside formulas
Formula basics notation, constants, evaluation order