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 |
|
meirninja
Starting Member
1 Post |
 Posted - 2009-11-25 : 04:06:14
|
| hello, i have created a Matrix out of my DS.i was able to create a total sum as a row at the end of the matrix thus each cell sums up the column above it. i did so through the right clik + sub total option.when i tried to make it an Avg calculation instead of a sum, i had encountered problems and didn't succeed doing so.i appreciate if someone could enlighten me about this... thanks,Meir |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-02 : 03:47:18
|
| assuming your matrix row group is rowgroup1 try expression like below for the row cells=IIF(Inscope("rowgroup1"),your current expression,AVG(Fields!yourfield.value,"rowgroup1")) |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2010-01-06 : 11:40:31
|
| You could have a calculated field with formula (rs!localtion1Hrs + rs!location2hrs) / 2.ORThe query used to show the report can have this field as calculated column.RAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 11:53:54
|
quote:
Originally posted by behrman
You could have a calculated field with formula (rs!localtion1Hrs + rs!location2hrs) / 2.ORThe query used to show the report can have this field as calculated column.RAQ Report: Web-based Excel-like Java reporting tool
will the above expression work? |
|
|
|
|
|
|
Making an Avg row at the bottom of a Matrix