Skip to Content

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

Running total reset on group change and formula based on line level

I am comparing a purchase order change history table and only want to see the lines were the Sales Order line had a change in Price, Quantity and Delivery Date as compared to the previous line (of that specific PO line). I grouped the records by PO # and then line number. I then added a sort order based on the changed date for the detailed records.

I am not sure if this is the best way, but I was trying to use running totals (maximum and minimum running total for the date and average running total for the price and qty). I want the running total to reset if a change took place (price, qty or date) and every time the group change.

Can somebody help with the formula, or if there is a better way of doing this?

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