Skip to main content

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())

Was this article helpful?

We're sorry to hear that.