Calculating: Total Weight = Product Masterdata Weight x Order Quantity

[coskunist]

Hello Gurus,

I need your help. I want to calculate: total weight of orders from product master data and order quantity. 

My model is like below:

I used a chart formatted as pivot, I have a calculated expression:

Total Weight = Sum(open order quantity) * Sum(UNIT WEIGHT)

The issue is that, when I drill up to GROUP1 as below, it gives wrong value.

For example: 21 x 30, 37 = 637,82. But I need to calculate as 38,89 x 10 + 22,30 x 10 =  611,9

[jonathandienst]

Hi

Something like this, perhaps:

Sum(Aggr(Sum([open order quantity]) * Sum([UNIT WEIGHT]), [MATERIAL CODE], GROUP1))

Hope that helps

Jonathan

[coskunist]

I used the formula as below, but it still calculates wrongly:

SUM( AGGR ( SUM([OPEN ORDER QUANTITY]), [MATERIAL CODE]  ) )  * SUM( TOTAL  <[MATERIAL CODE], GROUP1> [UNITWEIGHT]  ) 

[coskunist · Accepted solution]

My friend Serhan solved my problem.

We need to do as : SUM ( OPEN_ORDER_QTY x UNITWEIGHT )