Summing an editable table column and updating the value as they change

Summing an editable table column and updating the value as they change

  
Hi,

How would you sum a column and put it in the "total project cost" as shown in the example below?
Also, as users change the data in the edit table, it'd be great to update the total.

The project costs are "grouped by" projectId.

I would create an aggregate, but the aggreate probably would need updating inside the "on row update" and " on delete" and would also need to be in the preparation of this web form. Note sure how to do that. Is there a generic "OnTableupdate", to recalculate the total?

Hi Michael,

There's no OnTableUpdate but you can use the on row update and on row delete to update the total.
I think that you are on the right track. Having an aggregate that you refresh once you update or delete and showing that value (and refreshing it on screen).

So you would have the aggregate on the preparation and use Refresh Data on the actions of On Row Update and On Row Delete.

Cheers