Exceptional Aggregation Problem

[aditya_bakshi]

Hi My data is like this:

PO     Quantity          

1        10000

          10000

            7000

            7000

2        7000
          7000

          7000

3        7000

          7000

          7000

What i want is like this.

PO     Quantity          

1        17000            

2        7000
          

3        7000

How can it be done in BEx????

Thanks

[Former Member · Accepted solution]

Hi

See in exception aggregation you always have to choose the  reference characteristic which has unique values.

In your case you choose reference characteristic as condition type.Check ZFRP it is repeated so while taking average it is considered as 1 not 2.

check out this link for steps and screenshots of how to do this:

http://sap.learnatonce.com/Use-Exception-Aggregation.php

regards