Skip to main content

 

ThoughtSpot

About nested formulas

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

Nested formulas, or formula on formula, allow you to reference a formula within another formula.

This feature enables encapsulation/decomposition of formula logic and minimizes duplication by allowing a formula to reuse another formula. These formulas become columns, and are even suggested within the Formula Builder. Invalid formulas, such as cyclic or inconsistent aggregation formulas, are prevented from being created.

In addition, these formulas have dependency awareness, which ensure that you do not break any dependent formulas while editing a formula with dependent formulas. Some common cases of invalidating occur when you try to change a data type. Also, the system does not let you delete a formula that is nested in other formulas.

There is no limit to the number of nestings you can create.

Figure: formula1 nested in formula2

  • Was this article helpful?