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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2015 at 01:13 AM

    Hi David,

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

    Add comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded