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

Calculated key figure which show correct result, except for the total.

Hi S.A.P. Gurus!

we have the following problem in a BEX query:

we have three key figures in my query:

Restricted Key figure 1

Restricted Key figure 2

Calculated Key figure ( Restricted Key figure 1*100/ Restricted Key figure 2)

The result for each row for the calculated key figures is correct, except the for the total, which is wrong.

We have tried to define the Calculated key figure as:

Restricted key figure 1' %A 'Restricted key figure 2'

Restricted key figure 1 *100 /Restricted key figure 2

Also, we have created a new query, deleting all the other key figures, filters, characteristics, and so on... only with a characteristics for the rows, and those key figures...and the result is still the same.

For the old key figure, and the new ones all show the correct result per each row, except for the total.

We will be very thankful if someone could help us with this issue.

Thanks a lot in advance for your help!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 09:17 AM

    Raul,

    Waht exactly you mean by total? It is the result..?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi.

      Our query has a unique charasteristic "XX", and it shows information for that three key figures.

      In each row, we see information for the different values that that characterestic could have... with that three key figures.

      With the total, I meant the sum per column per each key figure (in the case of the restricted ones), and the division between that two totals for Calculated one.

      Cha X RKF 1 RK2 CKF

      X1 1 4 0,25

      X2 2 6 0,333333333

      X3 3 8 0,375

      Total 6 18 0,7

      Have a look to this sample, my query has the same problem, the unique wrong calculated by the CKF is the sum per RKF.

      In example the correct figure should be 0,333, and not 0.7

      Thank very much for your help!!

      Message was edited by:

      Raul Raul

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 10:04 AM

    Hi,

    make the properties of the CKF as " calculate result as" summation and try again.

    Thanks

    Ajeet

    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.