Order total does not update
I have an order app (similar to https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders), where I calculate the order total in a similar way:
SUM ( SELECT (Order Details[Total], [Order Id] = [_THISROW].[Order Id]))
When I add new items to the order, the order total does not update; it only updates when I go into the order, go into edit mode and save it again. In the AppSheet example order app, this step is not necessary.
Any idea what goes wrong in my app?