Rules for Standard Aggregation and Exception Aggregation 
The following table gives an overview of the rules for standard and exception aggregations in the BW system:
Abbreviation |
Aggregation Rule |
Description |
|---|---|---|
AVG |
Average (All Values) (Average of All Values) |
The average of all values is displayed. |
AV0 |
Average (Values not Equal to Zero) (Average of All Values < > 0) |
In a breakdown of the reference characteristic the average of the column values is displayed as not equal to zero in the result line. |
AV1 |
Average (Weighted with Number of Days) (Average Weighted with Calendar Days) |
In a breakdown of the reference characteristic the average of the column values weighted with the number of days is displayed in the result line. |
AV2 |
Average (Weighted with Number of Work Days; Factory Calendar) (Average Weighted with Working Days) |
In a breakdown of the reference characteristic the average of the column values weighted with the number of working days is displayed in the result line. |
CNT |
Counter (All Values) (Count All Values) |
The number of available values is displayed in the results line. |
CN0 |
Counter (Values not Equal to Zero) (Count All Values <> 0) |
The number of values <> zero is displayed in the results line. |
FIR |
First Value (First Value) |
The first value in relation to the reference characteristic is displayed in the results row. |
LAST |
Last Value (Last Value) |
The last value in relation to the reference characteristic is displayed in the results row. |
MAX |
Maximum (Maximum) |
The highest value of all displayed values in this column is shown in the results line. |
MIN |
Minimum (Minimum) |
The lowest value of all displayed values in this column is shown in the results line. |
NGA |
(No Aggregation of Posted Nodes Along the Hierarchy) |
No aggregation of postable nodes along the hierarchy. |
NHA |
(No Aggregation Along the Hierarchy) |
No aggregation along the hierarchy. |
NO1 |
(Exception if More Than One Record Occurs) |
No aggregation; The special value NOP is displayed is more than one record appears. |
NO2 |
(Exception if More Than One Value Occurs) |
No aggregation; The special value NOP is displayed is more than one value appears. |
NOP |
(Exception if More Than One Value <> 0 Occurs) |
No aggregation; The special value NOP is displayed is more than one value <> 0 appears. |
STD |
Standard Deviation (Standard Deviation) |
After drilling down according to the reference characteristic, the standard deviation of the displayed values is displayed in the results row. |
SUM |
Summation (Total) |
The total of all values in this column is shown in the results line. |
VAR |
Variance (Variance) |
After drilling down according to the reference characteristic, the variance of the displayed values is displayed in the results row. |