Signals Notebook: Discover the differences between the functions AVG, AVGIF, and AVGOVER

As an administrator, when defining table templates and when a created column/header is of type Number (excluding Integer and Number with Unit), users can define that the column/header is calculated using an equation. In these formulas it is possible to include different functions such as AVG, AVGIF and AVGOVER. Below you will find the difference between each of these functions. 

AVG: AVG function in the header equation lets you calculate the Average of a given numeric column using a single argument such as AVG(Arg1) where Arg1 is a numeric column. The AVG Function is available in the definition of equations for columns of type Number, whereby it will operate over the whole column defined as Arg1.

AVGIF: In a header column, you can define an equation to calculate values via conditional calculations, where the calculation is aggregating certain values in the table body, the selection of the values to be used being defined by the conditional calculation. This works for a Header of type Number or Text.

You can use the AVG(IF(Arg1, Arg2, Arg3)) expression where Arg1 is the condition being tested, Arg2 is the value included in the AVG (includes referencing a Numeric Column) if True, and Arg3 is the value included in the AVG if false (likely to be ““ or null).

AVGOVER: AVGOVER formula () lets you calculate the average of values from a specific column/header column over a group of matching values from a different column.

In case you want to explore other functions or view examples, we invite you to access the System Configuration Guide > Table Templates > Defining Equations.