I have an inventory table that calculates an inventory value by summing up child records. I want to have a workflow rule that triggers when this calculated value is changed, which happens when a child record is added/deleted/editted.
Setting the target data to the child records gets the trigger to work, but the rule doesn’t act on the parent records. Setting the target to the parent records makes the trigger not work. Any easy ways to make this work?