Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help for a calculated field

Status
Not open for further replies.

Josh1777

Programmer
Apr 22, 2009
8
IN
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top