Skip to Content

Question about KF

Hi,

I paste how is my query at this moment:

KF1 is a key figure coming from infoprovider.

KF2 is a function/key figure which uses KF1 and in the Calculation tab has the minimum for individual values.

The only thing wrong in FK2 in the total result which has to be 12 and not 8.

I have just create KF3 in order to user KF2 to achieve this but KF3 is really using KF1 data.

Can anybody help me?

Thanks in advance.

Regards.

Aggregation.jpg (16.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2015 at 05:26 PM

    Hi David,

    Are you displaying the display totals for any of the characteristic ? Please suppress the result rows and display only the final result and then see how it looks.

    As per what you have mentioned it should work correctly

    Regards

    Vivek

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2015 at 06:09 PM

    Hi David,

    so you choose KF2 calculation like below

    and for the same KF2 "aggregation" with some reference char?

    if yes, then it works only with specific char alone in rows! if you have more than one characteristic in rows, then it wont work as you expected. because summation will be applied only on the ref char you choose in key figure properties. you can check this by switching the reference char from your rows and see difference.


    exce_Agg.JPG (15.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2015 at 01:13 AM

    Hi David,

    Also define exception aggr on the KF2 (Summation with a Ref Characteristic)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2015 at 02:48 AM

    HI,

    for this requirement acheive two ways.

    1. applying the exception aggregation.

    for KF2 go to the exception aggreagation -> use the minimum -> hit the aggregation -> put the respective char .save it.

    2.in key figure tab

    in display tab -> calculate single values as - Minimum.

    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.