Skip to Content
0
Former Member
Apr 28, 2009 at 08:31 PM

How to perform this calculaction in Bex Query Designer on Overall Result

23 Views

Hi

How can i achieve this calculaction

Scenario

-


A--


B
C= Absolute(A-B)
--


D

X--


374,694
408,679.574

33,985.57
--


9.07 %

Y--


2,517,246 -1,548,085.141
969,160.86
--


38.50 %

Overall -2,891,940 -- 1,956,764.715 -- -1,003,146.43 --


32.34 %

Result

Overall Result of C should be 33,985.57 + 969,160.86 = 1,003,146.43

(Insted of Overall Result A - Overall Result B)

Which i achieved by

Query Designer >C >Properties >Calculactions (Tab) >Calculacte result as 'Total'

So every thing upto column C is correct

For Column D Calculaction should be Col C/Col A

Example : (33,985.57/ 374,694)*100 = 9.07

So 9.07 % & 38.50% calculactions are correct

But for Column D Over all result i want 1,003,146.43/2,891,940 = 34.68

(Based on the Overall result of Col C)

But it is performing (2,891,940 - 1,956,764.7150)/2,891,940 = 32.34%

Please advise how can i perform the Calculaction for Overall result of Col D

Thanks in advance

Edited by: bw trainee on Apr 29, 2009 7:39 AM