Difference between rows of data
Hi, I have a table with 2 rows that contain years 2011 and 2012. My columns are the months of the year and the values are amounts. I want to add a third row to find the difference between the two years for each month. So, If 2011 = $275 and and 2012 = $250 for October I need the row below to be $25. I was wondering how I would formulate my expression. Any help would be greatly appreciated!!! Dan
August 14th, 2012 2:41pm

Hi, As your row group has only two rows, one for 2011 and other for 2012, the below expression will work.. =RunningValue(Fields!amount.Value,Last,"month") - RunningValue(Fields!amount.Value,First,"month") Here month is the name of column group. Kindly revert if this is not the case.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
August 14th, 2012 3:02pm

=RunningValue((Last(Fields!amount.Value)-First(Fields!amount.Value)), Sum, "DataSet1") Thanks for the response! I have the code above, which results in an error. Is there anyway around this?
August 17th, 2012 12:49pm

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

Other recent topics Other recent topics