Subtotal wrong value
Column1
Column2
Row1
subrow11 2
6
diffrenz (6-2 = 4)
subtotal Subtotal of diffrenz: should be 4
Row2
subrow21 5
10
diffrenz (10-5 = 5)
subrow22 12
13
diffrenz (13-12 = 1)
subtotal
Subtotal of diffrenz: should be 5+1 = 6
Hi all,
above the matrix of my report from RS 2008R2. The subtotal value in each Subrow gives me always wrong values. I calculate it so: subtotal = sum(fields.diffrenz.value). Please do you habe an idea what i m doing wrong?
i add it as reading here http://msdn.microsoft.com/en-gb/library/ms170712.aspx
Thanks for your help!
newfon
November 24th, 2010 8:17am
Hi Newfon,
From the link you gave, I know your requirement, you have two rows to calculate the different value between two columns, just
like below report:
To the first total row, the value is contained in Date group, so you should add the scope to the SUM function, so it should be =SUM(Fields!Column2.Value,"Date")-SUM(Fields!Column1.Value,"Date"),
to the last total row, just type in the expression =SUM(Fields!Column2.Value)-SUM(Fields!Column1.Value)
For more knowledge about Inscope function, please click this blog written by Robert to learn more
http://blogs.msdn.com/b/robertbruckner/archive/2009/08/10/tablix-multiple-subtotals-are-easy-aka-goodbye-inscope.aspx
If
you have any question, please feel free to ask.
Regards,
Challen Fu
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 12:25am
thanks! It works now fine!
Newfon
November 29th, 2010 4:56am
Please mark the thread as Answered if the question is answer correctly.
Thanks
Kumarkk
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 8:28pm