Skip to Content
0

Running Total Getting Reset by Change of Group but Set to For Each Record

Apr 19, 2017 at 04:17 PM

40

avatar image

I have a group (BatchSeq) with details. I would like a running total based on an amount field on the change of 2 fields (PO number and PO Line). I created a formula to combine the PO Number and PO Line Item so I could use that in the reset ({APLB.PO}+Totext({APLB.POItem}). So it's using Amount, Sum, Evaluate for each record, reset with this formula.

I've placed the RunningTotal into the detail section as that's where I need it to evaluate. When it hits the first PO/POItem, it shows the correct amount, however, if that same PO/POItem combination appears later in the report on another BatchSeq, it's getting reset and not adding the previous value to the new one. It's like it's evaluating on the change of each group but I have it set to For Each Record.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Apr 20, 2017 at 07:57 AM
0

Hi Mercedes,

Insert a second group on the formula (PO Num + Line Item) you created.

Suppress this new Group Header and Group Footer.

Set the 'Evaluate' to 'On Change of Group' and select the formula field from the drop-down.

Set the 'Reset' to 'On Change of Group' and select the BatchSeq field.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded