Skip to Content
author's profile photo Former Member
Former Member

Problem with result calculation

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 08, 2008 at 01:41 PM

    Hello,

    tra to build your formula as a glabal calculated key figure.

    when doing so there is on the tab "aggregation" a checkbox for calculation before aggregation or after aggregation.

    please check if this has any impact on the results in yout query.

    best regards

    Cornelia

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 09:25 AM

    Hello Cornelia,

    I already had a global calculated key figure for the price (Value / Quantity).

    I have marked the checkbox for "calculation before aggregation", but it has no impact to the result.

    I use the price key figure for the calculation of the deviation.

    Moreover I defined all Keyfigures as global, but it is the same and I can only change the checkbox for the price keyfigure. For all other depentend the checkbox is greyed out.

    best regards

    Benjamin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.