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

[Former Member]

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!!!

[Former Member]

Hi,

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

Thanks

Ajeet

[Former Member]

Hi Ajeet.

Thanks for your suggestion!

But, that sums all the column for CKF... and the thing that I am looking for (what it is the unique thing wrong) it is the division between that two totals.

In the other email (in spite of the layout), I wrote an sample... I hope that it helps.

Thanks!!!

[former_member188325]

Hi,Set Calculate Result as ,Calculate single value as, and formula collision to 'nothing defined' for your formula/ckf...You shoud get correct total..i think Calaulate result as is set to 'summation' now.

[Former Member]

Hi,

try out the same stuff in the properties of the char present in the rows of the reports....this is will make the trick...and then try by removing this from the column of the key figures and put calculate result as to nothing defined again and rows char as summation for CKF only.

try it out and please let me know

Thanks

Ajeet

[Former Member]

Hi Ajeet!

Thanks for you answer.

But we cannot find out where we can set up the characteristic as you suggest.

Thanks in advance!

[Former Member]

Hi Muralidhar.

Thanks for your answer.

we have done it, but it doesnt change...

Thanks.

[Former Member]

Raul,

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

[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