How to get the CRM ID of a related record through expression

[joebordes]

the aggregation functions only work on the related records, so you do not need to add any conditions

Code:

aggregation('sum','Invoice','sum_nettotal')

that should do what you want.

Adding condtions would be for the case where you only wanted to sum the "Paid" invoices, for example

Give that a try