Skip to content

Formulas in financial statement templates

Standard formulas

When defining financial statement templates, standard formulas can be set on FST items. A standard formula can have the following elements as arguments:

  • other FST items of the current template
  • FST items of other templates with the same dimensionality (see Dimensionality details)
  • accounts, only in financial statement templates that depend on the account dimension only

For more details, see Standard formula syntax.

IMPORTANT: It is not possible to refer to an FST with multidimensional formulas (FST MD) from a standard FST.

Multidimensional (MD) formulas

Multidimensional formulas allow you to run operations between accounts and/or include other dimensions in operations. To create multidimensional formulas, called TGKML MD, the multidimensional script syntax TGKML is used. This syntax derives from the MultiDimensional eXpressions (MDX) language dedicated to OLAP analysis on the SQL Server. For more details on MGKML MD syntax, see Calculation logics of "Multi-Dimensional Script" type .

Financial statement templates containing multidimensional formulas can be used in forms based on the in-memory engine. For more details on multidimensional formulas, see Particular features of multidimensional formulas.

Formula for cube

Standard formulas are suitable for use in relational databases. However, a formula for cube can be created for every standard formula, to be used by external sources such as Microsoft Service. To create formulas for cube, the multidimensional script syntax TGKML is used. This syntax derives from the MultiDimensional eXpressions (MDX) language dedicated to OLAP analysis on the SQL Server. For more details on MGKML MD syntax, see Calculation logics of "Multi-Dimensional Script" type .