Print Page | Close Window

Sum of consecutive numbers

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20955
Printed Date: 19 Apr 2024 at 12:33pm


Topic: Sum of consecutive numbers
Posted By: kmailloux
Subject: Sum of consecutive numbers
Date Posted: 07 Aug 2014 at 3:53pm
I have a group which totals some values, in the group I also want to include a sum of the current value plus the 2 previous values. This need to be repeated in each group (the first 2 obviously won't total but that is ok.

Group       Value          90day
1                  10               10
2                    9                19
3                    7                26
4                   1                 17
5                    5                 13

Thanks



Print Page | Close Window