Using Formulae 
Use formulae to change the way numeric data is aggregated or calculated for a defined summary level.
Available functions are:
- SUM(). The total value.
- AVG(). The arithmetic mean.
- WAVG(). Weighted average.
Example: Working with formulae
Use the Equipment Measures report to look at the average and the total tonnes moved by the hauling and the loading equipment:
- Select Movements and Measures | Equipment Measures report type.
- Select the following:
Object Attribute Selected Value Site SiteA Period Shift Production Day Shift Thursday, September 16, 2010 Equipment Function Hauling, Loading Material Category Ore Measure Measure Tonne - Select the following Summary Levels:
Summary Level Value Equipment Function - Click Run Job. The report is displayed in Report View. Note that total tonnes = 26400.
- Select Data Browser.
- Note the values for the following columns:
Column Value Equipment All Other_Measure_Value 26400 Total tonnes moved by all the hauling and loading equipment = 26400.
- Click Formulas. The Other_Measure_Value is the only numeric column in the report. Therefore, it is the only column listed in the dialog. By default the Formula = SUM().
- Select the following:
Other_Measure_Value Value Formula
AVG() - Click Apply to exit the dialog and apply the setting.
- In the Data Browser, note the values for the following columns:
Column Value Equipment All Other_Measure_Value 13200
Average tonnes moved by the hauling and the loading equipment = 13200 .
- Click the Formulas icon again and select Formula = SUM().
- Click Apply. The Data Browser displays the following:
Column Value Equipment All Other_Measure_Value 26400 - Change the displayed summary level of Equipment by clicking on the Equipment plus sign +. All changes to Hauling and Loading summary level.
- Other_Measure_Value displays the total tonnes moved by Hauling and by Loading:
Equipment Other_Measure_Value Hauling
13200 Loading 13200
- Click Close.