Michael Katz
asked on
Running Total in Crystal Reports
GH1... $1,000.00
Detail RunningTotal
-100 900
-90 810
-80 730
-85 645
-75 570
Need a running total to reset, but have a column next to the Detail...I made my example "RunningTotal"
Detail RunningTotal
-100 900
-90 810
-80 730
-85 645
-75 570
Need a running total to reset, but have a column next to the Detail...I made my example "RunningTotal"
I assume that the figure in GH1 is from a field?
You could use a running total, but you would need a formula too.
Create a running total on the Detail column, set to reset for each group 1 (or wherever).
Create a formula like the following and put it next to the Detail field:
{GH1 field} + {#running total}
James
You could use a running total, but you would need a formula too.
Create a running total on the Detail column, set to reset for each group 1 (or wherever).
Create a formula like the following and put it next to the Detail field:
{GH1 field} + {#running total}
James
ASKER
I need the details to reset based on the GroupHeader...The Value in the Group Header could is a Number (not a summary)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When you say reset do you mean initialize to 1000?
If so, you can't use a running total.
Use 2 formulas
IN group header
Open in new window
IN the detail section to calculate and display
Open in new window
mlmcc