Skip to content

RowAvg

Calculates the average value of a list of numbers

Category: math

Syntax:

RowAvg([number1], [number2], ...)

Returns: Float

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
numbers number or column ✓ Yes Numbers to calculate the average of

Allowed Column Types for numbers: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 2
  • Maximum parameters: 10

Examples

RowAvg([Sales], [Marketing], [Support])

Calculates the average of Sales, Marketing, and Support columns for each row

RowAvg(10, 20, 30)

Returns 20 Result: 20

RowAvg([Q1], [Q2], [Q3], [Q4])

Calculates the average of four quarterly values for each row