Search
Search

# how to calculate with exception aggregation?

I need to make the following request by the customer.

In the report, one column (“accomplished Order”) should be marked with 1 if the requested quantity of a material is less than or equal to the stock and 0 if not. Also, the material is assigned to a "segment".

For instance:

MaterialSegment
1000003S1
1000004S1
1000005S2
1000006S3

Therefore, I must point out in another column (“accomplished Segment”) of the report if the segment meets or fails to meet with the above condition (1 = meets / 0 = not satisfied). If the segment does not meet at least one material of a segment, the entire segment must display 0.

Here I describe a layout of the report to make it clearer.

 Document Segment RequestedQuantity avalaible Stock Delivered quantIty Accomplished order accomplished segment Doc. 1 S1 4 10 4 1=Yes (4/10) 1 (yes) S1 2 2 2 1=Yes(2/2) S1 3 3 2 1=Yes  (3/3) S2 1 0 0 0=No (1/0) 0 (no) S2 2 2 2 1=Yes (2/2) S3 1 1 1 yes (1/1) 1 (yes) S4 4 6 4 yes (4/6) 1 (yes) Doc. 2 S1 1 9 1 yes(1/9) 1 (yes) S2 4 3 3 No (4/3) 0 (no) S2 3 3 3 yes(3/3) S2 2 1 0 No (2/1) S4 1 1 1 yes 0 (no) S4 2 0 0 No Doc. 3 S1 1 1 1 yes(1/1) 1 (yes)

I tried with a formula with an exception aggregation. The selected aggregation was “Min” and the reference characteristic  was “ZSEGMENT” (an infoobject that takes the value from the material atributtes), but it didn’t work.

I think it is difficult to calculate the indicator on the infoprovider since the user can filter the report on a date range, so the “accomplished segment” can vary according to the selected date.

So, can you give me an idea to calculate de Accomplished segment, please?

LUCAS

##### Former Memberreplied

Hi Lucas,

I just figured, accomplished order1 suits your accomplished segment requirement? isn't it? All segments (z01, Z02, Z03, Z04) are zero and other not assigned segment is 1.

you can just delete accomplished seg and make use of accomplished order1 by renaming it.

hope its clear.

1 View this answer in context