Querey formula Issue

[ShoaibAli]

I have been using Google sheet and applying Querey formula to get data from sheet1 and all data has formulation which will be used in other Sheet via Querey Formula. All data gets appear in other sheet but when i tried to sum the numeric values it gives 0.

Please share resolution.

=SORT(QUERY({'125th Medicaid'!A5:Z50},"Select Col1, Col6 where Col1 is not null",0),0,TRUE)