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

BaseValue

Use this function in an equation to find the first value for a symbol in a range, in the dimension specified in the By statement. For information on By, see By.

You can use the BaseValue function by itself to copy the first value into all the corresponding cells of another symbol in the calculation dimension. You can also use the BaseValue function to produce a value for use by another function. You can restrict the range of the BaseValue function in any dimension.

The order of calculation depends on the priority of the symbols in the dimension specified in a By statement.

Syntax:

BASEVALUE (SymName)

where:

  • SymName is a symbol in the calculation dimension.

Syntax example:

BVDelta = SaleT - BASEVALUE(SaleT)
Published:

BaseValue

Use this function in an equation to find the first value for a symbol in a range, in the dimension specified in the By statement. For information on By, see By.

You can use the BaseValue function by itself to copy the first value into all the corresponding cells of another symbol in the calculation dimension. You can also use the BaseValue function to produce a value for use by another function. You can restrict the range of the BaseValue function in any dimension.

The order of calculation depends on the priority of the symbols in the dimension specified in a By statement.

Syntax:

BASEVALUE (SymName)

where:

  • SymName is a symbol in the calculation dimension.

Syntax example:

BVDelta = SaleT - BASEVALUE(SaleT)
For an optimal Community experience, Please view on Desktop