Dataset:
Plant |
Initial non-cumulative |
A |
200 |
B |
300 |
C |
400 |
Plant |
Month |
Non-cumulative change |
A |
January |
50 |
A |
March |
100 |
B |
February |
30 |
B |
April |
40 |
C |
March |
30 |
C |
May |
30 |
Plant |
Validity |
A |
January - March |
B |
February - April |
C |
March - May |
Validity and Exception Aggregation AV1
Filter: Non-cumulative value with AV1, Plant = A,B |
|||
Month/plant |
A |
B |
Total |
January |
250 |
250 |
|
February |
250 |
330 |
580 |
March |
350 |
330 |
680 |
April |
370 |
370 |
|
Total |
284,44 |
343,48 |
627,93 |
The time filter is determined from the merge of the validities of plants A, B. For exception aggregation AV1, no values are determined outside the validity.
Validity and Exception Aggregation MAX
Filter: Non-cumulative value with MAX, month in [January - March], plant = A,B |
|||
Month/plant |
A |
B |
Total |
January |
250 |
[300] |
550 |
February |
250 |
330 |
580 |
March |
350 |
330 |
680 |
Total |
350 |
330 |
680 |
The time filter is determined from the global filter [January - March] and intersected with the merge of the validities of plants A,B ([January - April]). For plant B, the value for January, which is outside the validity, is added.
Validity and Exception Aggregation FIRST
Filter: Non-cumulative value with FIRST, month in [January - June], plant = A,B |
|||
Month/plant |
A |
B |
Total |
January |
200 |
[300] |
500 |
February |
250 |
300 |
550 |
March |
250 |
330 |
580 |
April |
350 |
330 |
680 |
May |
[350] |
[370] |
[720] |
Total |
200 |
300 |
500 |
The time filter is determined from the global filter [January - June] and intersected with the merge of the validities of plants A,B ([January - May]) that have been extended at the end because of the FIRST aggregation . For plant B, the value for January, which is outside the validity, is added. The value for May is added for both plants. For plant B, the value for May is different to the value for April, as there was no non-cumulative change yet in April, and initial non-cumulatives are displayed with FIRST aggregation.