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

Key Figure aggregated as average

Hi Folks,

I got a quick question in regards to aggregation. I got the requirement to have a certain key figure not to sum up when data is aggregated but it should display the average.

The raw data will have following structure (lowest granularity)

Material ProductLine Plant Rate

A PL1 P1 10

B PL1 P1 20

C PL2 P2 30

So whenever aggreagted it should average the rate. The report itself won't have anything in drill down but really just show the rate but use filters

So if filter is on P1 the report should display

15

No filter at all

20

Filter at A and C

20

I am a bit lost how to cover such a scenario - naive as I was I thought I can set average as aggregation setting for a key figure but there is only sum,min,max

Any inputs?

Thanks in advance,

Axel

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 12:56 PM

    hi,

    you can add another field 'counter' in the flow with a constant value 1.

    the rate can then be divided by the counter for the average calculation.

    Material ProductLine Plant Rate counter

    A PL1 P1 10 1

    B PL1 P1 20 1

    C PL2 P2 30 1

    So whenever aggreagted it should average the rate. The report itself won't have anything in drill down but really just show the rate but use filters

    So if filter is on P1 the report should display

    15 (10+20)/2 = 15

    No filter at all

    20 (102030)/3 = 20

    Filter at A and C

    20 (10+30)/2 = 20

    regards,

    Arvind

    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.