Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reset manual running total on each group

Due to the fact that I can not sum a formula I am using a manual running total, I found in a previous post, and it works great to get the grand total. However, I need to somehow setup one that will reset at each new group so that I have a total on each group. Any ideas on how I could accomplish this? Does this make sense?

Former Member
Former Member replied

In order to have a running total that resets at each group AND a grand total at the bottom, you would need essentially 5 formula fields.

The first three are for the group totals:

1) the running total field that has

i :=i+{@total}

2) a reset formula in the group header with

i:=0

3) a display formula for i in the group footer.

Then another 2 formulas using a different variable

1) the running total field (placed in the same section as your other one) with

 WhilePrintingRecords;
Global NumberVar X;
X :=X+{@Total}

2) a display formula for X in the report footer.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question