Summary fields are used for and act on found record sets. They are commonly used and placed in the (sub)summary parts or the footer of a layout for reports.
However, you want to calculate totals over relationships. For these, you need to use the Aggregate functions (Sum(), Count() etc.) in a calculation field.
I also tried a calculated field: in this case, using the SUM(relatedTable::field).
The result is absolutely the same.
The kind of relationship I built works when t1::field = t2::field but not when t1::field = t2::calculatedFieldFromTable3.
1 of 1 people found this helpful
Part of the issue may be that unstored calculations don't work well I'm relationships. The data should be stored.
If you can set the year in a script or auto enter / stored calculation the relationship should work.