Sum field based on different table not updating

[Naftuli_Singer]

Hi,

I have 2 tables, 1 for Groups and 1 for Customers, every customer is under a group, there is a Total field in the Groups table, which calculates the total for all customers under this group, with the formula:

Sum(Select(Customers[Total], [Group]=[Group Name])).

The problem is that it will only update when I edit this group row, and save again.
How can I make it update automatically?

[JuneCorpuz · Accepted solution]

You need to create a virtual column for that formula.

[marcomavil]

The virtual column works but then the correct sum is only shown in the app. The table is not updated until you edit and save again.

Is there a way to update the table total???

[JuneCorpuz]

You can run a scheduled bot to update the total in the table.