percentage is not calcluated in the detail band

[ilikejasper]

Hi

 

I have data in the format

Region ytd

Asia 5,789,777.43

Australia 1,553,008.88

Europe 30,546,788.71

Japan 8,134,018.72

US 113,661,762.06

 

 

I want to display Asia and percentage.

percentage = 5,798,777.43/159,685,355.80(sum of all the columns)

 

In the report i have made a sum function which calculate the total and the other field variable which point to ytd column

 

I am displaying the records in the detail band.

 

I do not get the correct percentage for any column because the total in the detail for the first time is

5,789,777.43 in detail band. In the second loop it changes to (5,789,777.43+1,553,008.88)

 

IS their any way i can calculate the total before execution of the detail band so that i get correct percentages.

 

Your expertise is required.

Thanks

ilikejasper

[Pedja]

If you are using a variable to calculate the sum, try setting it's Calculation type to Report or System. You can also experiment with Increment type.