I've been trying to solve what seems to be a simple issue with no success and hoping for your help. I have three objects. In two of the objects I have data imported from an external source ("project" in the screenshot). In the third object (dashed outline box in the screenshot) I would like to calculate the sum of data from the other two. The complication is I would need to do so without drawing a connector between them as in reality I have a few dozen shapes with data that need to be connected to a single object, and this pattern repeats multiple times in my diagram.
My solution at the moment is to group the three objects and have the following (example) formula: =SUM(DESCENDANTS."field_name") at the group level. I then have =PARENT."SUM_FIELDS" in the third shape to achieve the end result I am looking for.
Should be noted that it's not practical to reference specific field or object names as they may not be unique across the page.
This seems really inefficient, is there a better way to achieve this?
Thanks in advance!