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

Value

Use this function in an equation to get the value from an intersection of data, and to assign that value to an intersection of data, or to use it in a calculation.

Note: This function will only return numeric data. If the intersection contains a string value, then the function will return a zero (0).

Syntax:

VALUE ("DataAreaName","SymName0","SymName1", ..., "SymNameN")

where:

  • DataAreaName is the name of the DataArea in which the symbols are found, enclosed in double quotation marks.
  • SymName is the name of a symbol, enclosed in double quotation marks.

Syntax example:

VALUE ("daMaster","Acct1", "A1201", "Entity100", …, "WorkingVersion")
Published:

Value

Use this function in an equation to get the value from an intersection of data, and to assign that value to an intersection of data, or to use it in a calculation.

Note: This function will only return numeric data. If the intersection contains a string value, then the function will return a zero (0).

Syntax:

VALUE ("DataAreaName","SymName0","SymName1", ..., "SymNameN")

where:

  • DataAreaName is the name of the DataArea in which the symbols are found, enclosed in double quotation marks.
  • SymName is the name of a symbol, enclosed in double quotation marks.

Syntax example:

VALUE ("daMaster","Acct1", "A1201", "Entity100", …, "WorkingVersion")
For an optimal Community experience, Please view on Desktop