Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Symbol

Use this function to convert a text value into a symbol reference, which can then be used in a function or formula. This function is utilized when parameters for a "formula" are stored as data in the database.

It is possible to nest arguments within the main symbol call (for example, SYMBOL (), TIMEPERIOD, SYMBOL()...). Symbol() can also be used for the other dimension in the DataArea in functions that require symbols for other dimensions (such as VALUE or STRVALUE).

Syntax:

SYMBOL ()

SYMBOL Expression

where:

  • Expression is a data intersection to be resolved as a text string. If no expression is provided, the current symbol being calculated in the calculation block will be used.

Syntax example:

target = A1 + Symbol("A2")

or

Value (A1, Symbol(), Symbol(), Temp)
Published:

Symbol

Use this function to convert a text value into a symbol reference, which can then be used in a function or formula. This function is utilized when parameters for a "formula" are stored as data in the database.

It is possible to nest arguments within the main symbol call (for example, SYMBOL (), TIMEPERIOD, SYMBOL()...). Symbol() can also be used for the other dimension in the DataArea in functions that require symbols for other dimensions (such as VALUE or STRVALUE).

Syntax:

SYMBOL ()

SYMBOL Expression

where:

  • Expression is a data intersection to be resolved as a text string. If no expression is provided, the current symbol being calculated in the calculation block will be used.

Syntax example:

target = A1 + Symbol("A2")

or

Value (A1, Symbol(), Symbol(), Temp)
For an optimal Community experience, Please view on Desktop