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

Avg

Use this function in an equation to calculate the average value of a set of numbers.

Copy

Syntax

AVG (SymName[Structure], SymName[Structure])         

where:

  • Each SymName is a symbol, a series of symbols, or a range of symbols in the dimension specified in a CalculationBlock statement, whose total value you want to average.
  • 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.

Copy

Syntax example

Aver = AVG (AYR01#99)        
Published:

Avg

Use this function in an equation to calculate the average value of a set of numbers.

Copy

Syntax

AVG (SymName[Structure], SymName[Structure])         

where:

  • Each SymName is a symbol, a series of symbols, or a range of symbols in the dimension specified in a CalculationBlock statement, whose total value you want to average.
  • 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.

Copy

Syntax example

Aver = AVG (AYR01#99)        
For an optimal Community experience, Please view on Desktop