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

CalculationBlock

Use this function to define the DataArea to which subsequent calculations must be applied.

A CalculationBlock statement stays in effect until you end the CalculationBlock. A CalculationBlock statement applies only while you run the document in which it appears. After creating the CalculationBlock statement, you can use range functions to further limit the calculation to the DataArea specified in the DataSpec. You can also use the AttributeFilter function within a CalculationBlock to further refine the area affected by the calculations.

For more information, see AttributeFilter (CalculationBlock).

The dimension containing a symbol determines its calculation type.

Note: This function must appear before the statement to which it applies.

Syntax:

CALCULATIONBLOCK (CalculationDim[;RestrictedDim SymName [Structure][,SymName[Structure]]][;RestrictedDim SymName [Structure][,SymName[Structure]]])

//statements for this CalculationBlock End CalculationBlock

where:

  • CalculationDim defines the dimension that will be used in the calculation statements.
  • RestrictedDim is a dimension that will define a limited or restricted calculated DataArea.
  • SymName refers to the symbol name that will define a limited or restricted calculated DataArea.

    Note: To specify a range of symbols to limit the calculation to, enter the first and last symbols in the range, separated by a colon. For example, A0601:A0612.

  • [Structure] is the symbol structure that will define a limited or restricted set of symbols.

Syntax example:

CalculationBlock (TIMEPER; ACCOUNTS BALSHEET#99; ENTITIES W11110#99; DETAILS P1000#99)

A31120=0

End CalculationBlock
Published:

CalculationBlock

Use this function to define the DataArea to which subsequent calculations must be applied.

A CalculationBlock statement stays in effect until you end the CalculationBlock. A CalculationBlock statement applies only while you run the document in which it appears. After creating the CalculationBlock statement, you can use range functions to further limit the calculation to the DataArea specified in the DataSpec. You can also use the AttributeFilter function within a CalculationBlock to further refine the area affected by the calculations.

For more information, see AttributeFilter (CalculationBlock).

The dimension containing a symbol determines its calculation type.

Note: This function must appear before the statement to which it applies.

Syntax:

CALCULATIONBLOCK (CalculationDim[;RestrictedDim SymName [Structure][,SymName[Structure]]][;RestrictedDim SymName [Structure][,SymName[Structure]]])

//statements for this CalculationBlock End CalculationBlock

where:

  • CalculationDim defines the dimension that will be used in the calculation statements.
  • RestrictedDim is a dimension that will define a limited or restricted calculated DataArea.
  • SymName refers to the symbol name that will define a limited or restricted calculated DataArea.

    Note: To specify a range of symbols to limit the calculation to, enter the first and last symbols in the range, separated by a colon. For example, A0601:A0612.

  • [Structure] is the symbol structure that will define a limited or restricted set of symbols.

Syntax example:

CalculationBlock (TIMEPER; ACCOUNTS BALSHEET#99; ENTITIES W11110#99; DETAILS P1000#99)

A31120=0

End CalculationBlock
For an optimal Community experience, Please view on Desktop