In case you’re still confused —
Coda allows for recursive behavior. You can reference the same column within that column’s formula but only as long as you’re reading the values through a lookup somewhere.
See in my previous message how “Cumulative” is calculated with the use of “Cumulative” of the child nodes.
Here’s a clip from one of my lectures where I’m demonstrating the recursive behavior with digest cycles (aka recalculation passes). I was solving this problem btw. Watching at 1.5x advised.
P.S. I think you can totally apply the same thinking to solve it even if you have multiple tables there at play. This demo in the video actually had two tables interplaying so that @Connor_McCormick1 would accurately describe the composition. I always say it’s primary that you understand the principle, not just the formula someone gave you in the community 