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.

Copy

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.
Copy

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.

Copy

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.
Copy

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