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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics