SQL Sum not working v8. 1.6

Hi . The SQL code is not showing the sum when placed in the record count component

SELECT SUM(eccde_incomp) AS total_eccde_incomp
FROM schlist;

How should this be coded? My desire is to show the sum of the eccde_incomp on the dashboard record count widget, but the code above did not work in radsystems v8.1.6 but the same code works in phprad classic 2.7.x

I will appreciate a snippet to solve this. Thank you.