Skip to Content
0
Former Member
Jun 27, 2012 at 11:42 AM

Average in Bex query designer

371 Views

Hi all,

Below is my requirement. Kindly guide me.

Report:

Material-----TAX code-------document---line item-------miro value-----taxamount----netsales(miro value + tax amount)

m1-------------10-------------------d11-----------1-----------------70-----------------5-----------------350

m1-------------10-------------------d11-----------2-----------------10-----------------5------------------50

m1-------------11-------------------d21-----------1-----------------20-----------------10----------------200

m1-------------11-------------------d22-----------2-----------------30-----------------10----------------300

m1-------------11-------------------d23-----------3-----------------40-----------------10----------------400

After removing document and line item in drill down getting below wrong output.

Material-----TAX code-------miro value-----taxamount----netsales

m1-------------10--------------------80-----------------10-----------------800

m1-------------11--------------------90-----------------30----------------2700

Required Output

Material-----TAX code-------miro value-----taxamount----netsales

m1-------------10--------------------80-----------------5-----------------400

m1-------------11--------------------90-----------------10----------------900

Document line item wise i getting correct output. when going for summary result getting wrong because of Tax amount getting summation. I feel if i find TAX AMOUNT average based on TAX CODE will get correct output. i have tried giving average in EXCEPTION AGGREGATION and Local calculation but getting wrong result. Kindly guide me.

Thanks

saravanan