How to access aggregation variables from summary band

[DocJones]

Hello,

i have the following problem: I need to show a certain amount per branch and their percentage share related to the total amount:

Here is an example

Branch	Amount	%
A	1000	62,50 %
B	100	6,25 %
C	500	31,25 %
Total	1600	100,00 %

I could have done this using a subselect within my query, but technically spoken, this is a very inadequat solution, since it uses lots of performance (we are talking about roughly 1 Mio records to be calculated in total).

I defined a variable TOTAL with reset type "Report" that contains the correct amount (1600), but as soon as i try to calculate the %-Column  using "Amount/TOTAL", i am getting weird solutions.

Any help would be appreciated.

thanks

/D