Show TOC
# Rules for Standard Aggregation and Exception Aggregation

The following table provides an overview of the rules for standard aggregation and exception aggregations in the BW system.

Use

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) |
If you drill down to 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) |
If you drill down to 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) |
If you drill down to 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 result line. |

CN0 |
Counter (Values not Equal to Zero) ( Count All Values <> 0) |
The number of values <> zero is displayed in the result line. |

FIR |
First Value ( First Value) |
The first value in relation to the reference characteristic is displayed in the result line. |

LAST |
Last Value (Last Value) |
The last value in relation to the reference characteristic is displayed in the result line. |

MAX |
Maximum ( Maximum) |
The highest value of all displayed values in this column is shown in the result line. |

MIN |
Minimum ( Minimum) |
The lowest value of all displayed values in this column is shown in the result 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 if more than one record occurs. |

NO2 |
( Exception if More Than One Value Occurs) |
No aggregation; The special value NOP is displayed if more than one record occurs. |

NOP |
( Exception if More Than One Value <> 0 Occurs) |
No aggregation; The special value NOP is displayed if more than one value <> 0 occurs. |

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 result line. |

VAR |
Variance ( Variance) |
If you drill down to the reference characteristic, the variance of the displayed values is displayed in the result line. |