Average

Calculate the average (mean) of numeric values

Average formula is used to calculate the average (mean) of numeric values, such as calculating average prices, ratings, or any other numeric data in your app’s tables.

Syntax

Average(ThisItem.ColumnName1, ThisItem.ColumnName2,...)

• ThisItem : The identifier for the current row or record

• ColumnName: The column containing the numerical values you want to include for the average calculation

Example

Below is the English Test Result table with score of each student on their 4 skills Listening, Reading, Writing, and Speaking.

Requirement: find the Overall score which is the average of the 4 skills.

Formula:

Average(ThisItem.Listening, ThisItem.Reading, ThisItem.Writing, ThisItem.Speaking)

Result:

If the formula and data are correct, you can see the value of column 'Overall' in where you set to view it in the app.