Hello RFAWP.

The plugin cannot recognize the column as integer or float, since you have other characters in those columns besides numbers. Result is that the columns are being set as "string" values, where sorting logic is different than for number columns.

String type columns sort alphanumerically, so 1, 2, 3, 10, 12, 20, 25 is being sorted as 1, 10, 12, 2, 20, 25, 3...

You would need to remove everything else except for numbers in those columns to get it to sort and calculate sums properly.

Best regards.

Hello again RFAWP.

There are a few errors on the page:

_____________________________________

You have included the Google Maps JavaScript API multiple times on this page. This may cause unexpected errors.
 https://maps.google.com/maps/api/js?v=quarterly&language=en&key=AIzaSyCxidiGzQPuDw6Q04ZmL1mtPZtHGM1r6R4&libraries=geometry%2Cplaces%2Cvisualization&ver=5.2.1:147

_____________________________________

And another one referring to our bootstrap files:

_____________________________________

TypeError: Cannot read property 'error' of null
 /wp-content/plugins/wpdatatable/assets/js/wpdatatables/wdt.frontend.min.js?ver=2.3.1:3

_____________________________________

We've had complaints about Google Maps and wpDataTables being in conflict from some of our customers, so that may be the cause of these two errors. The best way to investigate would be to deactivate the Google Maps plugin and refresh the page. If the table loads without issues - that's the cause.

Unfortunately the issues like conflicts with third party plugins or themes are always possible due to the nature of WP, and it might take significant time to investigate and replicate the issue on our side, to be able to find the source of the problem, especially when the plugin or theme is not familiar to us. 

Best regards.