Was yor Sum() calculation set to be "Unstored" so it would always recalculate the calculation when needen?
Or was the calculation stored?
it is unstored. i'm making a simple test database to see if the problem is reproducable.
Refresh window[flush joined results] seems to fix the test case