AVGOF

  • 16 September 2022
  • 0 replies
  • 15 views

Userlevel 3
Badge +4

Description

Returns the average of all elements of a block. The function can be used on Lists Properties or Metrics of type Integer or Number.

 

Syntax

AVGOF(List.property) or AVGOF(Metric)

 

Return type

Number

 

Examples

Case

Results

Type

AVGOF(Employee.ID)

2

Number

AVGOF(Employee.Target)

1728.63

Number

 

with Employee (Dimension List):

ID (unique)

Name

Target

1

Ben

1500

2

Pierre

2789.3

3

Alan

896.6

(blank)

(blank)

(blank)


Excel equivalent: None

See alsoSUMOF


0 replies

Be the first to reply!

Reply