Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 20, 2017 at 07:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded