SUM related record costs

[Sarah_Keown]

Hi, I have a list of related records here, each with its own item cost. 

Is there an efficient way of providing a Total cost figure in the parent record? 

I have got a group aggregate with the total but I need to have it triggering something in the parent record i.e. if the costs are input and the Total is not equal to zero I need to update the Status and send a notification email with a report. 

[Aurelien]

Hi @Sarah_Keown 

"Is there an efficient way of providing a Total cost figure in the parent record"

I would do that with a new column, with app formula expression:

SUM([Related Part Request Details][Total Cost])

" I need to have it triggering something in the parent record"

Then the previous expression should be in a real column (not virtual).

And it should be update with an action that will write the result of this expression. Such action would be triggered on form save event at the Part table level.