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