I have a table that looks like this: Unique Value Date Time Stamp 3004605 4142499.2246927984 8/20/2012 3:00:06 PM 3004533 4142499.2246927854 8/20/2012 2:00:05 PM 3004422 4142499.2246927765 8/20/2012 1:00:08 PM 3004332 4142499.2246927655 8/20/2012 12:00:06 PM 3004261 4142499.2246927545 8/20/2012 11:00:07 AM 3004134 4142499.2246927444 8/20/2012 10:00:06 AM 3004011 4142486.8964438351 8/20/2012 9:00:08 AM I am creating a report in SSRS and want to show the difference between the the current row and previous so the report would look like Date DIfference 8/20/2012 3:00:06 PM 134 8/20/2012 2:00:05 PM 89 Help is appreciated....

Hi, How you want the difference to be calculated? How 134/89 is the diff between two rows?- Chintak (My Blog)

Sorry 4142499.2246927984-4142499.2246927854= 0.000000013 4142499.2246927854-4142499.2246927765=0.0000000089 The value column will always be either the same value as the previous or larger. Thanks

Hi There Thanks for your posting. Based on you scenario I think you can use the following expression to achieve your requirement =iif(previous(Fields!value.Value) is nothing, nothing,previous(Fields!value.Value)-Fields!value.Value) =iif(previous(Fields!value.Value) is nothing, nothing,previous(Fields!value.Value)-Fields!value.Value) Where I am assuming that Value is one of your dataset field name please change it according to your dataset field name. I am putting some screesnhot for your ghelp I hope this will help. If you have any questions please let me know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.