Skip to Content
0
Former Member
Apr 08, 2008 at 10:31 AM

Problem with result calculation

17 Views

Hello,

I have a problem with the results in the workbook.

I want to calculate a deviation of the prices from two different years. The calculation should be on single material number and then aggregated to material group.

The deviation = (Price (selected Year) - Price (previous Year)) * Quantity (selected Year)

When I have the material number in the drilldown the result (Summation) is okay, but when I remove the drilldown (then only materialgroup is in the drilldown) the result changed, because it will be calculated on the aggregated level and not on material number.

e.g.

Matgroup Matnr Quantity 2007 Quantitity 2008 Price 2007 Price 2008 Diff. % Deviation

Total 838,000 * 461,000 * 6,96 EUR 9,92 EUR 42,5 % -202,47 EUR

4711 Result 838,000 * 461,000 * 6,96 EUR 9,92 EUR 42,5 % -202,47 EUR 011392 84,000 VE 72,000 VE 4,95 EUR 2,04 EUR -58,8 % -209,32 EUR

011393 90,000 VE 72,000 VE 3,71 EUR 2,06 EUR -44,3 % -118,24 EUR

102078 527,000 ST 200,000 ST 2,98 EUR 2,64 EUR -11,3 % -67,04 EUR

PY-Y01 31,000 ST 36,000 ST 34,05 EUR 37,19 EUR 9,2 % 112,81 EUR

PY-Y02 35,000 ST 30,000 ST 35,99 EUR 37,19 EUR 3,3 % 36,00 EUR

PY-Y04 15,000 ST 27,000 ST 35,99 EUR 36,99 EUR 2,8 % 27,00 EUR

PY-Y05 36,000 ST 12,000 ST 12,04 EUR 12,64 EUR 5,0 % 7,20 EUR

PY-Y06 20,000 ST 12,000 ST 11,41 EUR 12,17 EUR 6,7 % 9,12 EUR

The Deviation is -202,47 EUR, but when I remove the drilldown for material number I get 1.364,98 EUR because he calculate with the result row only and not on Material number level.

Matgroup Quantity 2007 Quantitity 2008 Price 2007 Price 2008 Diff. % Deviation

Total 838,000 * 461,000 * 6,96 EUR 9,92 EUR 42,5 % 1.364,98 EUR

4711 838,000 * 461,000 * 6,96 EUR 9,92 EUR 42,5 % 1.364,98 EUR

I need -202,47 EUR displayd in the aggregated view.

Has someone an idea how I can do that?

Thanks in advanced,

Benjamin