Title perhaps misleading, but this is what I'm trying to achieve:
Consider three entities as follows:
Grandfather
Father
Son
On the Father entity, I have a Rollup that sums the amount of Sons he has, and on the Grandfather record, I have a Rollup that sums the total number of Grandsons. This is working great (I have a workflow that copies the number of Sons rollup value to a numeric field, and my Grandfather rollup is made up of these)....
However, if I change the status reason on Father to be, "Moved Away" for instance, I need that Father and his Sons to be excluded from the total rollup of total Sons on the Grandfather entity.
How can I achieve this? I'm trying to avoid any complicated javascript and use Rollups and Workflow tools if possible....
*This post is locked for comments
I have the same question (0)