Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    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 comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arvind,

      thank you very much for your reply. Sometimes the obvious solutions are hidden behind the less obvious ones. Thanks again which I could assign more than 10 points 😉

      Axel