Hi
How can i achieve this calculaction
Scenario
-
A--
D
X--
9.07 %
Y--
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