Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-09-01 : 05:22:01
|
| Hi Guys.I'm not sure if i'm doing something wrong here.I would like to work out the percentage of a value.What i have so far is a table with the following data.U_BUNI TotalSpentHOS 77.54DEV 43.00So if i use a pie chart and navigate to the label section.I have the following.=(Fields!Income.Value/SUM(Fields!Income.Value))*100All values return as 100.Can someone please assist. |
|
|
IceCreamWizard
Starting Member
11 Posts |
Posted - 2009-09-02 : 07:31:38
|
| Yeah, this is a weird thing about the pie charts. This will provide your fix:=Fields!Count.Value/Sum(Fields!Count.Value, "{The pie chart dataset")Instead of summing on the field values, you need to take the sum from the dataset when you use the Edit Expression window. |
 |
|
|
|
|
|
Percentage