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

SumArea

Use this function to sum an area in a DataArea to a single value. This function must be used within a calculation block. This function can be used in two ways: to assign a value to a calculation block, and to evaluate for multiple slices in a calculation block. This function works in conjunction with the Symbol function.

Syntax:

SumArea (SymName,[Structure], SymName)

where:

  • SymName is a symbol name.
  • Structure is a range of symbols.

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

Syntax example:

SumArea(TrialBalance###, Period_01:Period_03, Total_Entities)

SumArea(TrialBalance###, Period_01:Period_03, Symbol())
Published:

SumArea

Use this function to sum an area in a DataArea to a single value. This function must be used within a calculation block. This function can be used in two ways: to assign a value to a calculation block, and to evaluate for multiple slices in a calculation block. This function works in conjunction with the Symbol function.

Syntax:

SumArea (SymName,[Structure], SymName)

where:

  • SymName is a symbol name.
  • Structure is a range of symbols.

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

Syntax example:

SumArea(TrialBalance###, Period_01:Period_03, Total_Entities)

SumArea(TrialBalance###, Period_01:Period_03, Symbol())
For an optimal Community experience, Please view on Desktop