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?