Browse by category
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, use All functions (A-Z) instead.
How to find the right function
Start with your goal, then choose the relevant function group:
Connect uploaded data to nodesData access →Calculate or transform numeric valuesMath & numeric →Apply business rules or conditional logicLogical functions →Filter, pick, rank or fill missing dataFiltering & data shaping →Change the result’s shape or granularityDimensionality & hierarchies →Project values forward or build cumulative time logicRollforward & time series →Compare values across timeCompare periods →Use finance-specific methodsFinance functions →Control assumption effects or combine resultsAssumptions & 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