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 |
|
ecomajor
Starting Member
12 Posts |
 Posted - 2009-02-23 : 11:08:08
|
| I know this a common question but I cant seem to figure out how to do this from searching around.1) When I add a subtotal on a matrix if the field is a percentage I dont get the right value in the subtotal. An Example Employees with Cars %with CarsNew York 5 1 20New Jersey 10 3 30Total 15 4 50For some reason I am getting the sum of the percentages as opposed to the right result which is about 27%. I know I need to use inscope for this situation but I am unsure how to do so.Please help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 10:31:46
|
| =IIF(Inscope("Yourgroupname"),your expression, SUM(Fields!WithCars.value,"yourgroup")/SUM(Fields!Employees.value,"yourgroup")) |
 |
|
|
|
|
|
Subtotals on a matrix