Skip to Content
0
Former Member
Jul 05, 2011 at 09:21 AM

Calculation issue with BEx query

460 Views

Hello Friends,

I have a BEx query in the following format:

Material Qty1 Qty2 Value

M1 1 4 4

M2 2 5 10

M3 3 6 18

Total 6 15 32

Here Value = Qty1*Qty2

The "Total" row shows the sum for all columns when the query is at material drill down level.

As soon as I remove the drill down for Material, in the overall result row, it shows 90 for "Value".

So at material drilldown it does an addition, while when we remove the drilldown it does multiplication.

I want the figure of 32, at the overall result level.

Please help me fix this.

Regads,

Bhushan