Nested formulas, or formula on formula, let you reference one formula from within another, with no limit to nesting depth.Nested formulas, or formula on formula, let you reference a formula within another formula. These formulas become columns, and are even suggested within the Formula Builder — there’s no limit to the nesting depth you can create. Invoca doesn’t allow you to create invalid formulas, such as cyclic (looping) or inconsistent aggregation formulas. To support this, formulas have dependency awareness: you can’t delete a formula that’s nested inside another, and Invoca ensures that editing a formula doesn’t break any formulas that depend on it. A common case of invalidation happens when you try to change a data type. Nesting enables encapsulation and decomposition of formula logic — for example, one team member can create small, reusable formulas that others build on, minimizing duplication.
Insights & Analytics
Nested Formulas
Last modified on September 23, 2026
Was this page helpful?