Aggregation on grid column is not working

Hey guys, Having a grid sourced with an entity which I am taking over association from other entity. I have chosen the Aggregation - Sum but I can only see "Total" and no result. This is working when I am taking entity direct from the database. What could be the problem? I need aggregation on associated entity. Could you guys suggest something.
1 answers

Here's a thread from a few years back with the same issue - no apparent resolution.

Given that you're running 4.7.1, It's possible this was fixed in a later release of MX4. I recommend trying to reproduce this in a test project on a newer version of Mendix 4. If you can reproduce the issue, submit a support ticket with your sample project attached.