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 |
|
cseward
Starting Member
24 Posts |
 Posted - 2015-06-15 : 12:54:20
|
| I have a simple matrix. The row group is schoolname. The column group is tweek. and the data field is thours (sum(thours)). on the right side of my matrix, I want to display the Average hours for all the week columns. SSRS can do a sum very simply, but when I use the avg function, I get erroneous results. I've googled this problem and can't find an explanation that I understand. Do I somehow use the inscope function in the data field ?? I just don't know. and I don't understand how to use the inscope function |
|
|
kostya1122
Starting Member
15 Posts |
Posted - 2015-06-15 : 21:02:56
|
| maybe sum(thours)\DATEDIFF(DateInterval.WeekOfYear,startdate,enddate) |
 |
|
|
cseward
Starting Member
24 Posts |
Posted - 2015-06-16 : 08:03:25
|
| your solution has the scope problem as well :(But, thank you for the suggestion :) |
|
|
|
|
|
|
SSRS need help using inscope with a matrix