Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

AVG & AVGR

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

Introduction

The AVG and AVGR formulas allow you to calculate the average of a number of values.

Syntax

AVG

(Parameter0 + Parameter1 + Parameter2 + etc.)
The parameters are references to list items of the parent list.

AVGR

(Parameter0:Parameter1) / # Parameters

Example

AVG

CXO-Cockpit - Design Studio - Create Formula - Formula Editor - AVG.png

AVGR

CXO-Cockpit - Design Studio - Create Formula - Formula Editor - AVGR.png

CXO-Cockpit - Design Studio - Create Formula - Report - AVG.png