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