Formula Expression contained Variable

treyscheid — Fri, 13 Mar 2026 22:44:32 GMT

When using formula builder (in insight formulas) I often use the same logic or references multiple times. Excel has the LET function to define a variable contained within the scope of the formula. This improves maintainability and legibility. Does this type of function or feature exist?

Here is a simplistic use case; but, often there may be need for multiple variables and nested variables.

/* current */ if( isNull(sum(SCHEMA.TABLE.COL)), 0, sum(SCHEMA.TABLE.COL) ) /* desired */ let(var_name, sum(SCHEMA.TABLE.COL), if( isNull(var), 0, var ) )

topic Formula Expression contained Variable in Dashboards & Analytics Discussions

Formula Expression contained Variable