I have a calc field using Get ( RecordModificationCount ) on child, grandchild records that are summed on the parent. All works nicely except for when I delete one of these records. What I'm aiming for is that the sum of the record modifications increases with any modifications, but only ever increments upwards. If one of the dependent records is deleted, I don't want to lose any modification count associated with it.
I'd thought of saving the summed count in a variable, but's not much use since I can't 'reset' the sum fields value back to what it was before the deletion of the dependent record.