help for a calculated field

[Josh1777]

i have 2 fields:
Region Name field2 field3
-------------------------------
Central 0.47588
East 0.05197
North 0.40546
South 0.42523
West 0.37039

Now I want field3 to show the values as field2(1)/TOTAL(field2)
Ex: above total is 1.72893, so central fielsd3 value should be = 0.47588/ 1.72893 ==> 27.5245383
Output should display as

Region Name field2 field3
-------------------------------
Central 0.47588 27.5245383
East 0.05197 3.00590539
North 0.40546 23.4514989
South 0.42523 24.5949807
West 0.37039 21.4230767


How to do this on report studio

 

[blom0344]

try:

[field2]/(total[field2] for report)

Ties Blom