Hi- I dug through the archives and found this helpful bit from Robert Bruckner from September 2005:

Sum(Fields!Reg_Hours.Value) / Sum(Fields!Reg_Hours.Value,
"MatrixRowGroupName")

I'm doing this; no error, but getting 100% for each item in my group. Any suggestions? 99% (ha) of what I do is distribution reporting, so this will be SO helpful if anyone can assist!
Thanks

From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm

Posted via DevelopmentNow.com Groups

please get each value of Sum(Fields!Reg_Hours.Value) and
Sum(Fields!Reg_Hours.Value,"MatrixRowGroupName")..
is it different?? why? which one is correct?



"Elle" <nospam@developmentnow.com> дÈëÏûÏ¢ÐÂÎÅ:23b5eea2-37e4-4b25-a927-a995d3f3a135@developmentnow.com...
[quoted text, click to view]

Let me back up--
I'm trying to get percents off a group. Total group = 100%, each item in the group is some portion adding up to 100%. There has GOT to be an easy way to do this!

Obviously each item divided by itself will give me 1 or 100%. I was hoping this reference to the "MatrixRowGroupName" for the denominator would help it recognize I want to divide the section into the total for the group and not itself...

Hope that helps clarify. Anyone have any suggestions? Thanks!

From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=963686

Posted via DevelopmentNow.com Groups

Let me back up--
I'm trying to get percents off a group. Total group = 100%, each item in the group is some portion adding up to 100%. There has GOT to be an easy way to do this!

Obviously each item divided by itself will give me 1 or 100%. I was hoping this reference to the "MatrixRowGroupName" for the denominator would help it recognize I want to divide the section into the total for the group and not itself...

Hope that helps clarify. Anyone have any suggestions? Thanks!

From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=963686

Posted via DevelopmentNow.com Groups