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)