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 nodes → Data access
• Calculate 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