In this article
Formulas in aggregated tables calculate new values not directly evaluable by Data Engine, supporting specific data types and using a syntax tree in requests.
About Formulas
Formulas allow calculating new values in aggregated tables that are not possible to evaluate by Data Engine during table aggregation. Formulas can access aggregated values in a table and evaluate new values.
A formula is represented in Tabular Engine requests as a syntax tree similar to that of a Data Engine expression. Common expression element types have the same representation in formulas, however there are Data Engine expression node types that are not supported in formulas. On the other hand, there are specific node types only valid in formula expressions.
Formulas work with a subset of data types defined in Data Engine.
The following data types are currently supported in formulas:
Null
Integer
Integer vector
Real
Real vector
Text
Text vector
Bool
Bool vector