How do I share date between multiple tables? I want the parent table to aggregate the data from the child table
You can do that for example with a formula… SUM(SELECT([RelatedChildRecords][ValueColumn],TRUE))
should work too
Aleksi’s above formula (with SELECT) was the only way it worked and introduced when filtering Ref lists was originally released a year ago; COUNT() worked without SELECT though, but it was necessary in SUM() function; sounds like it has been improved and now SUM() works without SELECT too.
Here is the original post for a trip down memory lane! https://plus.google.com/116466377064499551355/posts/2pYP8FvUucn
Thanks Aleski, it worked like a charm