Hi, I have the following code that I need some help with. RunningValue((Last(Fields!amount.Value)-First(Fields!amount.Value)), Sum, "DataSet1") This results in an error because there is an aggregate inside another aggregate. Is there anyway around this? Basically what I am trying to do it once I find the difference between the two amounts, I would like to have a running difference as well. Any help would be greatly apprecaited!! Dan

Hi, Kindly have a look at below thread to see if this help you http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/4563c797-df05-43bf-80d1-e1757d06daf6/ Please revert if you face any difficulty.- Chintak (My Blog)

Chintak has provided an excellent link. If you are using a SQL query that will work. You can accomplish the same thing in MDX if you have an OLAP database too. My personal rule of thumb is if the database can do it easily, like running totals, etc, then it should go there.Robert Attaway The SQLMDX Dude sqlmdxdude@gmail.com