Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My friend Serhan solved my problem.
We need to do as : SUM ( OPEN_ORDER_QTY x UNITWEIGHT )
Hi
Something like this, perhaps:
Sum(Aggr(Sum([open order quantity]) * Sum([UNIT WEIGHT]), [MATERIAL CODE], GROUP1))
Hope that helps
Jonathan
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] )
My friend Serhan solved my problem.
We need to do as : SUM ( OPEN_ORDER_QTY x UNITWEIGHT )